How do I hide the worksheet menu bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro recorded in a game that optimises the view of the game on
screen in all but one respect. When I have tried to add in the following
command it always trips up and launches the debugger:

Application.CommandBars("Worksheet Menu Bar").Visible = False

Can anyone help? All I want to do is hide the menu bar when the user clicks
the 'optimise view' button and reset everything back to normal when the
'close game' button is clicked.
 
Application.CommandBars("Worksheet Menu Bar").Enabled = False


--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)
 
Thanks very much!!

Bob Phillips said:
Application.CommandBars("Worksheet Menu Bar").Enabled = False


--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)
Click to expand...
 
You must log in or register to reply here.

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

MAJOR PROBLEM! --- Menu Bars don't unhide? 9
hide formula bar (and menu bar etc) 2
List Visible Controls in CommandBars("Worksheet Menu Bar") 3
Customise Button on toolbar 1
hiding the Menu bar 2
menu bar and error 91 3
Hide menu bar 1
disable a menu control short key 1

Back
Top