Deleting a Command Bar
You can delete toolbars and menu bars from the Customize dialog box or by using Microsoft® Visual Basic® for Applications (VBA). You can delete pop-up menus only by using VBA. Use the Delete method of the CommandBars collection to remove an existing command bar from the collection. The following procedure illustrates one way to delete a CommandBar object:
Function CBDeleteCommandBar(strCBarName As String) As Boolean On Error Resume Next Application.CommandBars(strCBarName).Delete End Function
An error will occur if strCBarName is not the name of an existing command bar. The procedure uses the On Error Resume Next statement to ignore this error because, if an error occurs, it means there is nothing to delete. In addition, it could mean you tried to delete a built-in command bar, such as Standard, which cannot be deleted.
Working with Command Bars | Manipulating Command Bars and Command Bar Controls with VBA Code | Getting Information About Command Bars and Controls | Creating a Command Bar | Hiding and Showing a Command Bar | Copying a Command Bar | Preventing Users from Modifying Custom Command Bars | Working with Personalized Menus | Working with Images on Command Bar Buttons | Working with Command Bar Controls | Working with Command Bar Events