| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Toolbars Question
CommandBars("WorksheetMenuBar").Enabled = False
will hide the bar. The converse will redisplay it. -- Vasant "Full Monty " wrote in message ... Excel 97 - I read a post a couple days ago explaining how to hide all the toolbars when opening a workbook, then unhide them when that workbook is closed. The only thing it left open was the Worksheet Menu Bar. I thought this was pretty cool but wondered about a couple of things. Can you do the same thing except leave open a Custom toolbar you created and close the Worksheet Menu Bar? And if so is the code pretty much the same? Or is it another ball of wax? Since I am learning VBA as I go along, I thought I would get some opinions on this! Thanks! --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Basic VBA question - hiding rows | Excel Discussion (Misc queries) | |||
| Hiding all toolbars | Excel Discussion (Misc queries) | |||
| Hiding all Toolbars | Excel Programming | |||
| Hiding toolbars but keeping the Windows Menu Bar? | Excel Programming | |||
| Question about toolbars ... | Excel Programming | |||
Threaded Mode
