If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Toolbar Macro Template

Thread starter Big_Dawg
Start date Dec 4, 2008
Tags

commandbars toolbars visible

Big_Dawg

New Member

Dec 4, 2008

I need a macro that will hide all visible toolbars with the exception of select few. I have tried everything. Nothing seems to work. Loops do not seem to work well with "Application.commandbars". I need a macro that will only display the following:

Application.CommandBars("Standard").Visible = True
Application.CommandBars("Custom1").Visible = True
Application.CommandBars("Formatting").Visible = True
Application.CommandBars("PivotTable").Visible = True
Application.CommandBars("Visual Basic").Visible = True

All other are Visible = False.