MrExcel Publishing
Your One Stop for Excel Tips & Solutions

startup macros to remove toolbars plse hlp

Posted by stuart purvis on January 14, 2002 2:51 PM

I have a couple of spreadsheets setup for our network users. I want to turn off the toolbars just on certain spreadsheets.

Posted by Qroozn on January 14, 2002 2:58 PM

Application.DisplayFullScreen = True
Application.CommandBars("Worksheet Menu Bar").Enabled = False

and set to true on your exiting macro.