menu and toolbars missing

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

Guest

Excel menu and all toolbars are missing from the display. ALT+f does
nothing. Only thing displayed is formula bar and name box. Nothing else.
Can't get it back
 
One way is to reset all the toolbars to factory defaults. This will mean that
you'll lose any customized changes to any of your toolbars.

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

Restart excel and see if that fixed it.

If it did, you can delete those *.xlbOLD files.

If it didn't help, just close excel and rename them back to *.xlb.

======
You could also be a little more selective.

Open excel
hit alt-f11 (to get to the VBE where macros live)
hit ctrl-g (to see the immediate window)
type this and hit enter:
application.commandbars("worksheet menu bar").enabled = true

Then back to excel and try to use:
tools|customize to reset/show any toolbar you need.
 

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

Back
Top