How do I save a customized toolbar

W

WP2Worduser

Every time I customize by Excel toolbar and then restart my computer, the
toolbar reverts back to the default. Where are these settings saved?
 
G

Gord Dibben

Manual 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

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.

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

Table of content - format does not get saved 2
Blank Page After Envelope-Label Wizard 5
Is it possible to edit colours already saved as part of a custom theme? 0
Save a custom chart as a template 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Can I edit macro buttons on the quick access toolbar in excel? 0
Excel file won't save to iCloud on Mac 0
My custom number list doesn't seem to save? 1

Top