Excel Menu Bar Lost

  • Thread starter Thread starter John Jeffery
  • Start date Start date
J

John Jeffery

This is a follow-up to my previous post.

I have somehow lost the main menu bar (File, Edit, View,
etc) in Excel 2000 and cannot get it back. I have
run 'detect and repair' but that didn't correct the
problem. Can anyone help me?

It will not come back using the 'customise' function.

It is not 'hidden' as the short-cut keys don't operate.

I have made a temporary fix by creating a custom bar and
adding the commands to it, but this is not fully correct -
every Title e.g. 'File' has a drop-down arrow at the side,
and the 'Alt +' keys don't operate for this type of custom
bar. I had to make this bar so that I could look if there
was anything in the 'Options', but couldn't find any help
there.

My boss says he was trying to change something and he
thinks he deleted it!!!! - (They think they know
everything).

Any help to get back the original bar would be much
appreciated.

John Jeffery.
 
John

With a workbook open, hit ALT + F11 to get to the Visual Basic Editor.

View>Immediate window

Copy/paste the code line below into the Immediate window and hit <ENTER>

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

ALT + Q to get back to Excel with, hopefully, a restored Worksheet Menu

Gord Dibben Excel MVP
 
Bob

Try this alternate method.

With a workbook open.

Again, hit ALT + F11 to get to VBEditor.

CRTL + R to get Project Explorer. You will see your workbook/project name in
the list on the left.

Right-click on the name and Insert>Module.

Paste this code in there.

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

Up on the VBEditor Menu you will see a "Run" menu item. Select that and "Run
Macro".

ALT + Q to go back to Excel window. Is your Worksheet Menu Bar restored?

If it is, close the workbook without saving and close Excel and re-open.

Gord
 
Back
Top