Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard Toolbar is missing
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard Toolbar is missing
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" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard Toolbar is missing
And you included that second line (the .reset line), too?
BRB wrote: 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" wrote: 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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard Toolbar is missing
Yes, I did, but still greyed out.
"Dave Peterson" wrote: And you included that second line (the .reset line), too? BRB wrote: 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" wrote: 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard Toolbar is missing
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. BRB wrote: Yes, I did, but still greyed out. "Dave Peterson" wrote: And you included that second line (the .reset line), too? BRB wrote: 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" wrote: 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 -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard Toolbar is missing
Thanks Dave. It worked!!
Back to normal. "Dave Peterson" wrote: 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. BRB wrote: Yes, I did, but still greyed out. "Dave Peterson" wrote: And you included that second line (the .reset line), too? BRB wrote: 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" wrote: 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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing Standard Chart Types | Charts and Charting in Excel | |||
Changes to standard toolbar | Excel Discussion (Misc queries) | |||
Standard/Formating Toolbar | Excel Discussion (Misc queries) | |||
Fax Button on Standard Toolbar | Excel Discussion (Misc queries) | |||
Standard andFormatiing toolbar | Excel Discussion (Misc queries) |