Worksheet menu Bar Missing

S

SS

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

Anyone know how to restore it back

Cheers
Shona
 
D

Dave Peterson

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