Make "Worksheet Menu Bar" invisible or Delete/hide it's buttons
 

To hide a control, just use

Application.Commandbars("Worksheet Menu Bar").Controls("File").Visible =
False

set it true to rest back.

To hide the worksheet menu bar, use

Application.Commandbars("Worksheet Menu Bar").Enabled = False


--

HTH

Bob Phillips

"mcpheat" wrote in message
...
Hi folks,
Thanks to Bob and Tom for the help recieved last time, here is my next
question.

I want to "customise" the "worksheet menu bar" with some controls in vb
ie remove most of them (file, edit, view, insert etc) and add other ones.

On exit, i want to restore the toolbar as if i
"right clicked" on any toolbar
Selected "customise"
selected "worksheet menu bar" and hit "reset"

If i simply add the menu options back again (file, edit, view, )
they need to be rebuilt as the are "headings" only.


I also tried to hide the Worksheet Menu Bar with the following
Application.CommandBars("Worksheet Menu Bar").Visible = False
as this would be PREFERABLE but got a runtime error
"method 'visible' of object 'commandbar' failed"

Thanks for any help you may be able to offer