Excel Menu Bar Lost

[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.

 

[Gord Dibben]

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