menu bar Excel 97

  • Thread starter Thread starter casket44
  • Start date Start date
C

casket44

I am using Excel 97 and a coworker using my computer managed to hide
the menu bar. I cannot seem to figure out how to get it back on
screen. Any suggestions?
Thanks.
 
Try going to Tools | Customize.
Click on the Toolbars Tab.
Look down the list of Toolbars for either Men Bar or Worksheet Menu Bar
(can't remember the exact name).
Make sure it has a check next to it.

tj
 
tj

Pretty hard to with no Menu Bar showing, but if OP has any Toolbar
showing.......

Right-click and "Customize" and follow tj's steps from there.

If no Toolbars available............

ALT + F11 to get to Visual Basic Editor.

CRTL + G to open Immediate Window

Paste this code in there and hit <ENTER>

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

Hit ALT + Q to return to Excel Window. Menu appears?

Gord Dibben Excel MVP
 
oops.
Sorry about that.

tj

Gord Dibben said:
tj

Pretty hard to with no Menu Bar showing, but if OP has any Toolbar
showing.......

Right-click and "Customize" and follow tj's steps from there.

If no Toolbars available............

ALT + F11 to get to Visual Basic Editor.

CRTL + G to open Immediate Window

Paste this code in there and hit <ENTER>

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

Hit ALT + Q to return to Excel Window. Menu appears?

Gord Dibben Excel MVP
 

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

Back
Top