Unhide Main Menu Bar

D

Dkline

Another person here wrote a macro which hides Excel's Main Menu Bar. Is there
a non-programming way to unhide the main menu bar?

I've tried using Alt-T to get to the Tools menu on the main bar but,
seemingly, if the main menu bar isn't visible, Alt-T doesn't work.

This little gift from the macro writer has now "infected" a few machines.
 
B

Bob Phillips

You could right-click anywhere in the remaining toolbars, and choose
Customize, select the Toolbars tab, and hit the Reset button.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
G

Gord Dibben

Bob

I find that if Worksheet Menu Bar has been disabled it will not show up in the
Customize>Toolbars dialog so can't be reset.

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

needs the following to become enable again

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

Any other method?

Gord
 

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

Top