Lost the excel menu list at top of worksheet

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?
 
J

John Wilson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top