Lost the excel menu list at top of worksheet

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

The list starting with file, edit view is no longer at
the top of my screen. If I use the control panel it still
will not correct any way of deliting the menu files and
reloading them?
 
Rob,

Go into the VBA Editor (Alt + F11)
Select View/Immediate Window
An "Immediate" window should appear at the bottom of the screen.
Type the following (or cut and paste) and press enter:
Application.CommandBars("Worksheet Menu Bar").Reset
Then type (or cut and paste the following) and press enter:
Application.CommandBars("Worksheet Menu Bar").Enabled = True

If the above doesn't work, search your drive for a file with a .xlb
extension (search for *.xlb). Either move or delete the file,
close and restart Excel.

John
 
Back
Top