Resets a built-in command bar to its default configuration, or resets a built-in CommandBarControl to its original function and face.
Note
The use of CommandBars in some Microsoft Office applications has been superseded by the new Ribbon user interface. For more information, search help for the keyword "Ribbon."

Syntax

expression.Reset

expression A variable that represents a CommandBarControl object.

Remarks
Resetting a built-in control restores the actions originally intended for the control and resets each of the control's properties back to its original state. Resetting a built-in command bar removes custom controls and restores built-in controls.

Example
This example uses the value of user to adjust the command bars according to the user level. If user is "Level 1," the command bar named "Custom" is displayed. If user is any other value, the built-in Visual Basic command bar is reset to its default state and the command bar named "Custom" is disabled.

Visual Basic for Applications 
Set myBarControl = CommandBars("Custom").Controls(2) If user = "Level 1" Then myBarControl.Visible = True Else CommandBars("Visual Basic").Reset myBarControl.Enabled = False End If
ofv

See also: