How can I restore the menu and tool bars in Excel?

D

Dave Peterson

You could try:
tools|customize|toolbars
and select each and click reset

or you could just blow away all of your toolbars and rebuild any customized
changes at your leisure.

If you want to try the second...

Close excel
windows start button|search/find
look for *.xlb
rename all of them *.xlbOLD

then reopen excel and test it out.

If it worked ok, search for *.xlbOLD and delete them.

If it didn't, rename them back to *.xlb.
 
D

Dave Peterson

Excellent point <bg>.

I'd use the other suggestion!

But first....

Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
Application.CommandBars("worksheet menu bar").Visible = True

then back to excel to see if you have the menubar.
 
Top