Standard Toolbar is missing

[Guest]

I'm not sure what I did wrong, but last Friday I opened an Excel file I
received from a co-worker and noticed the "SAVE" icon was greyed out. I
closed the file and opened a new one and it is still greyed out. When I right
clicked in the toolbar area I noticed the STANDARD toolbaroption was not
there.
Can someone help me get the STANDARD toolbar back? and the SAVE icon?
Thanks,

 

[Dave Peterson]

Maybe...
Right click on an empty spot on the toolbar
Select Customize
Make sure Standard is checked
and then select Standard and hit the reset button

If you can't Standard from the Customize dialog, you can try this:

Hit alt-f11 (to see the VBE)
hit ctrl-g (to see the immediate window)
type this and hit enter:
application.commandbars("standard").enabled = true
then type this and hit enter:
application.commandbars("standard").reset

 

[Guest]

Thanks Dave!!!! The VBE option brought back the icons.

However, the SAVE icon is still greyed out and the file is not READ ONLY..

 

[Dave Peterson]

And you included that second line (the .reset line), too?

 

[Guest]

Yes, I did, but still greyed out.

And you included that second line (the .reset line), too?

 

[Dave Peterson]

Tools|Customize (just to see that dialog)
rightclick on the save icon
click reset

If that doesn't work, you can reset all the toolbars.

Close excel
Windows start button|Search
look for *.xlb
in hidden folders, too

Rename them all to *.xlbOLD and restart excel to see if it helps.

If it doesn't help, rename them back to *.xlb.

If it does, delete those *.xlbOLD files and recreate any customized toolbars.

Yes, I did, but still greyed out.

 

[Guest]

Thanks Dave. It worked!!
Back to normal.

Tools|Customize (just to see that dialog)
rightclick on the save icon
click reset

If that doesn't work, you can reset all the toolbars.

Close excel
Windows start button|Search
look for *.xlb
in hidden folders, too

Rename them all to *.xlbOLD and restart excel to see if it helps.

If it doesn't help, rename them back to *.xlb.

If it does, delete those *.xlbOLD files and recreate any customized toolbars.