Worksheet menu Bar Missing

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

In customize tools the option to select or deselect the above is missing.

Anyone know how to restore it back

Cheers
Shona
 
Open excel
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this in and hit enter
Application.CommandBars("worksheet menu bar").Enabled = True
back to excel and test it out.

If it didn't work, you can kill your existing toolbar file and it'll reset every
customization you've ever made.

close excel
windows start button|find/search for *.xlb

rename them to *.xlbOLD

Back to excel to see if everything is back to normal. If you like it, just
delete those *.xlbOLD files. If you don't like it, close excel and rename them
back to *.xlb.
 
You must log in or register to reply here.

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

Similar Threads

Missing worksheet menu bar Excel 2003 5
Missing Formula Bar 2
Quick Access Tool Bar 1
excel 2002 2
Access Textbox - Hide Cursor 0
Excel 2003 worksheet menu bar was missing 2
Count sheets in workbook 3
Data drop down on the menu bar missing 1

Back
Top