Getting Excel 2003 to save Custom Toolbars
 

I want to be able to set my Custom Toolbars to my personal favorite settings
and then have Excel save those customized settings forever. Now, whenever I
close and re-open Excel 2003 it always reverts back to the default factory
settings, and I must spend 5 minutes re-setting them every time!!! It is
incredibly frustrating.
MIKE MEDLIN
MIKEMEDLIN (remove

Mike

Manual customizations to Toolbars and Menus are saved in a file named *.XLB

XL2000 and 2002 *.xlb file will be in Documents and
Settings\yourname\application data\microsoft\Excel and be Excel9.xlb
or Excel10.xlb

Excel 97 in C:\Windows and named username.XLB

Ecel 2003 same as 2000 and 2002 and named Excel11.XLB

Perhaps this file is going astray? If on a server, this can happen.

Also if on a server, you may not have permissions to save. See your IT guy or
Administrator.

Search for *.xlb and see what you come up with. When you get your
customization done, make a backup copy of the *.xlb file.

When you search for *.xlb you may come up with more than one. Make some
changes to your Toolbar or Menu then save and close Excel.

Check to see which *.xlb updated. That would be the one to backup.


Gord Dibben Excel MVP

On Tue, 7 Dec 2004 11:03:02 -0800, "MIKE MEDLIN" <MIKE
wrote:

I want to be able to set my Custom Toolbars to my personal favorite settings
and then have Excel save those customized settings forever. Now, whenever I
close and re-open Excel 2003 it always reverts back to the default factory
settings, and I must spend 5 minutes re-setting them every time!!! It is
incredibly frustrating.
MIKE MEDLIN
MIKEMEDLIN (remove