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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've lost all my menu and tool buttons in MS Excel. How can I restore them?
 
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.
 
Thanks Dave,
But with no tool bar, how do I go to "tools|customize|toolbars"?
 
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.
 
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

Quick Access Tool Bar 1
Menu Bar disappear 1
Speech Recognition & Dictation in Excel: How to turn it on? 0
Best Tool to Repair Corrupted PDF Files 0
Missing worksheet menu bar Excel 2003 5
'Cannot insert object' message when I try to put a button on a worksheet 7
In Excel 2007 Can I keep my macros under Menue button like 2003? 1
missing the menu bar 2

Back
Top