Lost Menu Bar

Posted by sandy bender on April 15, 2001 4:19 PM

My menu bar in excel is gone. The one with File, Edit etc. It is not one of the toolbars that I can activate. How do I get it back.

Thanks

Sandy

Posted by Sandi F on April 15, 2001 4:28 PM

Posted by Sandy on April 15, 2001 4:31 PM

Worksheet Menu Bar is not there. I am also using excel 2000 if that helps.

Thanks

Posted by Sandy on April 15, 2001 4:44 PM

Did not work

Worksheet menu bar is not there. I am using excel 2000 if that helps.

Thanks

Posted by Dave Hawley on April 15, 2001 5:26 PM

Hi Sandy

Push Alt+F11
Go to Insert>Module
Paste in this code:

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

Make sur the mouse insertion point is within the Sub.
Push F5
Push Alt+Q to return to Excel.

Is it Back ?

Dave
OzGrid Business Applications

Posted by Sandy on April 15, 2001 6:01 PM

Worked Perfectly. Thanks for the help.

It worked great thanks. : Worksheet Menu Bar is not there. I am also using excel 2000 if that helps. :

Hi Sandy Push Alt+F11 Go to Insert>Module Paste in this code: Sub RestoreMenu Application.CommandBars("Worksheet Menu Bar").Enabled=True End Sub Make sur the mouse insertion point is within the Sub. Push F5 Push Alt+Q to return to Excel. Is it Back ? Dave