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/