Saving Toolbar Settings on Office Pro XP

A

Andy Shaker

How do I retain my Toolbar settings so that the icons and
toolbars I select once, continue to appear each time I
open Excel XP?
 
G

Gord Dibben

Andy

Customizations 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

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

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

One more fact about *.xlb files. If they become too large, they
have been known to cause problems with Excel.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I edit macro buttons on the quick access toolbar in excel? 0
Need to increase font size in MS Office 2013 in Windows 10 1
Keeping to ms office 97 pro 0
Excel 2016 odd behavior 1
Insert name and adress from a list in a word document 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
How to remove external organization from Office. 0
Section and Page numbering 0

Top