menu and toolbars missing

M

marzeats

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
 
M

marzeats

Nothing. There is no File/Edit/View/Insert/... menu and there are no toolbars.
 
D

Dave Peterson

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