I took this VBA out of the tips and must have used in incorrectly.
Maybe a bad choice for my second one to try. I placed it in the ope
command and it took away the menu bars but I cant get them toggle
back. It shows that way on all of my excel application. Help


Sub ToggleCommandBars()
Dim cbEnabled As Boolean
' get the current commandbar state
cbEnabled = Not Application.CommandBars(1).Enabled
' apply the new state to the Workbook Menu Bar
Application.CommandBars(1).Enabled = cbEnabled
' apply the new state to the Standard toolbar
Application.CommandBars("StandardOPE").Enabled = cbEnabled
' apply the new state to a custom commandbar (the oposite of th
previous two)
Application.CommandBars("MyCustomCommandBar").Enab led = No
cbEnabled
End Su

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements