Lost Menu Bar

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

If done it now - - I lost my menu bar completely -
it's gone to outter space - how do I get
File,Edit, etc back ??? I've tried to find it in help and
cannot. Can you please help
 
Press ALT+F11, Insert > Module, and run this macro:

Sub Restore_MenuBar()
Application.CommandBars.ActiveMenuBar.Enabled = True
End Sub
 
Donna,

The following copied from a previous post by Chip Pearson...

John

<snip>
First, trying searching for and removing (or at least moving to another
location) a file with the "xlb" extension. The name and location will
depend on
a number of things. Search for *.xlb .

Also, try running the code

Application.CommandBars("Worksheet Menu Bar").Reset
Application.CommandBars("Worksheet Menu Bar").Enabled = True
<snip>
 
If you have any (other) toolbars open, you should be able
to right click any of them. You'll see a list of toolbars
and at the bottom should be "Customize...". Click that.

In the resulting dialog box, click the Toolbars tab,
scroll down and turn on the checkbox for "Worksheet Menu
Bar".
 
Back
Top