CommandBarControl.Reset method (Office)

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 component of the Microsoft Office Fluent user interface. For more information, see Overview of the Office Fluent 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.

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

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.