how do you make menu bar show?

B

BrianG

My menu and tool bar disappeared and I can't figure out how to get them to
show. Anyone know a command to get it?
 
P

PDUK1

Try this:

View>Toolbars>Customize

Go to the toolbar tabs and place a tick in the toolbar that you want
displayed.

The second to last menu bar is the default worksheet menu bar

HTH

Regards

Peter
 
G

Gord Dibben

Brian

No menu at all?

Hit ALT + F11 to open Visual Basic Editor.

Hit CRTL + G to open Immediate Window.

Copy/paste this into that window.

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

Now hit <ENTER> key.

Your menu should be restored.

What turned it off? Perhaps you have some code in your workbook?

Gord Dibben Excel MVP
 
Top