where are toolbar changes stored?

P

Philip Reece-Heal

In Excel 2002
When making changes to toolbars or menus, that information must be stored in
some sort of file. What is the name of that file and what is it's normal
location?
 
B

Bob Umlas

if sPath = Application.StartupPath then the location of the toolbar file
is
Left(sPath, InStrRev(sPath, "\")) & "Excel" & Val(Application.Version) &
".xlb"
and for xl2002 is named Excel10.xlb, I believe.
 
L

Luke M

Default location:
C:\Program Files\Microsoft Office\OFFICE11\XLSTART
(Note the number in 'OFFICE' may be slightly different, depending on version)
file name:
Personal.xls
 
S

Sheeloo

Excel 2003 -
"The settings are saved in a workbook called Excel.xlb. If the file cannot
be not found, try making a simple alteration to a toolbar, then use the
Windows Start menu option to Find Files with the wildcard '*.xlb'."

Source: http://www.meadinkent.co.uk/xlconfigure.htm

Should be the same for Excel 2002...
 
G

Gord Dibben

Toobar and Menu changes are stored in Excel10.XLB file for Excel 2002

C:\Documents and Settings\username\Application Data\Microsoft\Excel


Gord Dibben MS Excel MVP
 
G

Gord Dibben

Luke

Not since the introduction of Excel 97 when Excel did away with the Menu
Editor, have Toolbar changes been part of Personal.xls


Gord Dibben MS Excel MVP
 
Top