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?

--
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/

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)




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Stan Brown" wrote in message t...
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?

--
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/

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\E xcel\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/

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.

Stan Brown wrote:

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\E xcel\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/

--

Dave Peterson

Stan Brown wrote:

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\E xcel\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/

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?

Stan Brown wrote:

Stan Brown wrote:

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\E xcel\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