Removing the Expand Button from a ToolBar

The Expand Button is the button displayed at the end of a toolbar and it displays a list of the buttons on the toolbar so that the user can easily hide or show them. At the bottom of the list is a customize option to further customize the toolbars.

The code below will remove the Expand Button from all the tool bars.

CommandBars.Options.ShowExpandButtonAlways = False

You can also hide the Expand Button for toolbars on an individual basis. To do this, you need to set the value of the ShowExpandButton property for each individual toolbar. This can be used to override the effects of ShowExpandButtonAlways for individual toolbars.

The code below will show the Expand Button for the first toolbar. Note that CommandBar(1) is the ActiveMenubar.

CommandBars(2).ShowExpandButton = True