View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Standard Toolbar is missing

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

BRB wrote:

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