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/