diabling the worksheet menu bar?

R

Rich Cooper

Is it possible to disable the worksheet menu bar and also when a use right
clicks on it disable the popup menu allowing a use to add or remove a
toolbar. Can either or both be disabled?
 
B

Bob Phillips

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

disable shortcut key from menu control 1
disable Edit/Cut menu option (and other specific ones) 1
menu bar and error 91 3
Menu-bar missing when launching Excel 9
having trouble disabling "save", "save as" (2003) 6
msoControlButton to "Worksheet Menu Bar" ? 3
Cell Toolbar Dilemma xl2013 13
List Visible Controls in CommandBars("Worksheet Menu Bar") 3

Top