customize a toolbar

P

Patryce

I customized my Excel 2002 toolbar just the way I like it. When I re-boot,
all my settings are gone. How can I keep my settings everytime I open Excel?
I was able to keep my toolbar settings with Excel 97
 
D

David McRitchie

close all of your open workbooks that you see, then
unhide your personal.xls workbook and have only that workbook open.
Set your toolbar settings as you want them, Then close your personal.xls
and close Excel.

The first file opened controls the settings and that would be your
personal.xls file. After opening Excel hide your personal.xls workbook
and you should be okay. Close Excel. And you are back in business
your personal.xls workbook will be the first workbook to open and it is
hidden.
 
G

Gord Dibben

Patryce

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

close all of your open workbooks that you see, then
unhide your personal.xls workbook and have only that workbook open.
Set your toolbar settings as you want them, Then close your personal.xls
and close Excel.

The first file opened controls the settings and that would be your
personal.xls file. After opening Excel hide your personal.xls workbook
and you should be okay. Close Excel. And you are back in business
your personal.xls workbook will be the first workbook to open and it is
hidden.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Patryce said:
I customized my Excel 2002 toolbar just the way I like it. When I re-boot,
all my settings are gone. How can I keep my settings everytime I open Excel?
I was able to keep my toolbar settings with Excel 97
Click to expand...
Click to expand...
 
Top