Reset all toolbar customizations

[Stan Brown]

I know I can do View | Toolbars | Customize | Toolbars and reset one
toolbar at a time. Is there any convenient way to reset them all in
one go, without using a macro?

 

[Ron de Bruin]

Delete your xlb file

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you.
(You lost your customization remember that)
If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it)

 

[Stan Brown]

Sun, 6 Jan 2008 10:41:51 -0500 from Stan Brown

I know I can do View | Toolbars | Customize | Toolbars and reset one
toolbar at a time. Is there any convenient way to reset them all in
one go, without using a macro?

Sun, 6 Jan 2008 17:13:06 +0100 from Ron de Bruin

Delete your xlb file

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you.
(You lost your customization remember that)
If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it)

Thanks, Ron, but there doesn't seem to be any .xlb file. This is
someone I'm trying to help, and it's Excel 2003 (Excel11). The
toolbar customizations seem to be in the Registry, at this key:

[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options]
"CmdBarData"=hex:c6,24,00,00,01,01,00,00,00,00,00,00,51,00,03,00,00,00,02,01,\
ff,ff,09,01,00,00,08,01,00,01,01,00,02,00,00,01,02,01,01,00,00,1a,00,e0,03,\

and it goes on for several pages like that in the exported .REG file.

I suppose I could just tell him to delete that registry key?

 

[Dave Peterson]

If the toolbars have been customized, then the user has a *.xlb file.

My bet is that you're just missing it in your search.

Make sure you're looking in hidden folders in your search.

Another way to search for that *.xlb file is to use an old DOS command:

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

Make a note of the locations of the found files.

Sun, 6 Jan 2008 10:41:51 -0500 from Stan Brown

I know I can do View | Toolbars | Customize | Toolbars and reset one
toolbar at a time. Is there any convenient way to reset them all in
one go, without using a macro?

Sun, 6 Jan 2008 17:13:06 +0100 from Ron de Bruin

Delete your xlb file

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you.
(You lost your customization remember that)
If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it)

Thanks, Ron, but there doesn't seem to be any .xlb file. This is
someone I'm trying to help, and it's Excel 2003 (Excel11). The
toolbar customizations seem to be in the Registry, at this key:

[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options]
"CmdBarData"=hex:c6,24,00,00,01,01,00,00,00,00,00,00,51,00,03,00,00,00,02,01,\
ff,ff,09,01,00,00,08,01,00,01,01,00,02,00,00,01,02,01,01,00,00,1a,00,e0,03,\

and it goes on for several pages like that in the exported .REG file.

I suppose I could just tell him to delete that registry key?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

 

[Stan Brown]

Thanks, Ron, but there doesn't seem to be any .xlb file. This is
someone I'm trying to help, and it's Excel 2003 (Excel11). The
toolbar customizations seem to be in the Registry, at this key:

[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options]
"CmdBarData"=hex:c6,24,00,00,01,01,00,00,00,00,00,00,51,00,03,00,00,00,02,01,\
ff,ff,09,01,00,00,08,01,00,01,01,00,02,00,00,01,02,01,01,00,00,1a,00,e0,03,\

and it goes on for several pages like that in the exported .REG file.

I suppose I could just tell him to delete that registry key?

Tue, 08 Jan 2008 09:06:30 -0600 from Dave Peterson

If the toolbars have been customized, then the user has a *.xlb file.

My bet is that you're just missing it in your search.

Make sure you're looking in hidden folders in your search.

Thanks for the response, Dave. I'm confused, though.

(1) You say "search for hidden folders", but I thought it would have
to be in c:\Program Files\Microsoft Office\Office11\XLSTART, which is
present but empty. (Yes, I have hidden files displayed.) His Tools |
Options | General "At startup, open all files in" is an empty box.

(1) What is that CmdBarData registry value for?

 

[Dave Peterson]

My toolbar is not in my XLStart folder. In fact, my toolbar is in XLStart's
parent folder.

I use xl2003 and winxp home.

My XLStart folder:
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART

Location of my *.xlb file:
C:\Documents and Settings\David Peterson\Application Data\Microsoft\Excel

I've never played with the cmdbardata registry. Sorry.

Did you try the old DOS command?

Thanks, Ron, but there doesn't seem to be any .xlb file. This is
someone I'm trying to help, and it's Excel 2003 (Excel11). The
toolbar customizations seem to be in the Registry, at this key:

[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options]
"CmdBarData"=hex:c6,24,00,00,01,01,00,00,00,00,00,00,51,00,03,00,00,00,02,01,\
ff,ff,09,01,00,00,08,01,00,01,01,00,02,00,00,01,02,01,01,00,00,1a,00,e0,03,\

and it goes on for several pages like that in the exported .REG file.

I suppose I could just tell him to delete that registry key?

Tue, 08 Jan 2008 09:06:30 -0600 from Dave Peterson

If the toolbars have been customized, then the user has a *.xlb file.

My bet is that you're just missing it in your search.

Make sure you're looking in hidden folders in your search.

Thanks for the response, Dave. I'm confused, though.

(1) You say "search for hidden folders", but I thought it would have
to be in c:\Program Files\Microsoft Office\Office11\XLSTART, which is
present but empty. (Yes, I have hidden files displayed.) His Tools |
Options | General "At startup, open all files in" is an empty box.

(1) What is that CmdBarData registry value for?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

 

[Dave Peterson]

I just looked and I don't have this key
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options\CmdBarData

And I have customized my toolbars--including the built-in toolbars.

I did search google and there were very few hits. One suggested deleting this
key to avoid a crash.

I still think you're missing the *.xlb file in your search. If you really don't
have one, then you shouldn't have any customized toolbars to reset.

My toolbar is not in my XLStart folder. In fact, my toolbar is in XLStart's
parent folder.

I use xl2003 and winxp home.

My XLStart folder:
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART

Location of my *.xlb file:
C:\Documents and Settings\David Peterson\Application Data\Microsoft\Excel

I've never played with the cmdbardata registry. Sorry.

Did you try the old DOS command?

Thanks, Ron, but there doesn't seem to be any .xlb file. This is
someone I'm trying to help, and it's Excel 2003 (Excel11). The
toolbar customizations seem to be in the Registry, at this key:

[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options]
"CmdBarData"=hex:c6,24,00,00,01,01,00,00,00,00,00,00,51,00,03,00,00,00,02,01,\
ff,ff,09,01,00,00,08,01,00,01,01,00,02,00,00,01,02,01,01,00,00,1a,00,e0,03,\

and it goes on for several pages like that in the exported .REG file.

I suppose I could just tell him to delete that registry key?

Tue, 08 Jan 2008 09:06:30 -0600 from Dave Peterson

If the toolbars have been customized, then the user has a *.xlb file.

My bet is that you're just missing it in your search.

Make sure you're looking in hidden folders in your search.

Thanks for the response, Dave. I'm confused, though.

(1) You say "search for hidden folders", but I thought it would have
to be in c:\Program Files\Microsoft Office\Office11\XLSTART, which is
present but empty. (Yes, I have hidden files displayed.) His Tools |
Options | General "At startup, open all files in" is an empty box.

(1) What is that CmdBarData registry value for?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

 

[Stan Brown]

Sun, 13 Jan 2008 09:18:26 -0600 from Dave Peterson

Sorry, somehow I missed this in your earlier note:I'll go and look there.
^^^^^ Oops!

I just looked and I don't have this key
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options\CmdBarData

And I have customized my toolbars--including the built-in toolbars.

I did search google and there were very few hits. One suggested
deleting this key to avoid a crash.

I still think you're missing the *.xlb file in your search. If you
really don't have one, then you shouldn't have any customized
toolbars to reset.

Thanks Dave. I should have mentioned, I Googled myself before
posting, and I didn't find anything useful either.

I don't know where I got the idea, but I had it in my head that there
must have been customizations because the CmdBarData toolbar was
present. From what you say that must not be true.

Just another Excel mystery, I guess. Maybe CmdBarData had meaning in
an earlier version of Excel but no longer does.

 

[Dave Peterson]

I thought maybe it had something to do with the positions of each commandbar,
but I rearranged toolbars, closed excel and still didn't see that key.