Excel Guides

Controlling the Display of Toolbars in Excel

There are a few ways to control the display of toolbars in Excel. One way is to use the Customize Toolbars dialog box. To access this dialog box, choose Tools > Customize from the menu bar. In the Customize Toolbars dialog box, you can select which toolbars are displayed and which are hidden. You can also customize the toolbar by adding, removing, or rearranging buttons. Another way to control the display of toolbars is to use VBA. The following code will hide all toolbars except for the Standard and Formatting toolbars:

Application.CommandBars("Worksheet Menu Bar").Visible = False
Application.CommandBars("Chart").Visible = False
Application.CommandBars("PivotTable").Visible = False
Application.CommandBars("Drawing").Visible = False
Application.CommandBars("Picture").Visible = False
Application.CommandBars("Clip Art").Visible = False
Application.CommandBars("Media Clip").Visible = False

If you want to show all toolbars again, you can use the following code:

Application.CommandBars("Worksheet Menu Bar").Visible = True
Application.CommandBars("Chart").Visible = True
Application.CommandBars("PivotTable").Visible = True
Application.CommandBars("Drawing").Visible = True
Application.CommandBars("Picture").Visible = True
Application.CommandBars("Clip Art").Visible = True
Application.CommandBars("Media Clip").Visible = True

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.