Turning off the Main Menu bar [Archive]

Click to See Complete Forum and Search --> : Turning off the Main Menu bar

daved2424

Feb 5th, 2004, 07:15 AM

I am trying to turn off the main menu command bar in Excel. Why does this code not work?

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

Many Thanks

TheFIDDLER

Feb 7th, 2004, 07:19 PM

I think this is what you are looking for:

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