Saving Custom Toolbars in Excel 2003


G

Guest

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 this)@HOTMAIL.COM
 
Ad

Advertisements

G

Gord Dibben

Mike

See answer in excel.misc.

Please refrqain from multi-posting.

All the regulars monitor all the excel news groups.

Multi-posting tends to fragment answers and can be a waste of time when
answers are duplicated.

If you MUST post to more than one group, please cross-post, not multi-post.

Gord Dibben Excel MVP
 
D

donny808

MIKE said:
*I want to be able to set my Custom Toolbars to my personal favorit
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 defaul
factory
settings, and I must spend 5 minutes re-setting them every time!!!
It is
incredibly frustrating.
MIKE MEDLIN
MIKEMEDLIN (remove this)@HOTMAIL.COM *



Mike,

I am having the same problem, did you fix yours? If so, please help m
with mines...thanks.

Donn


-
donny80
 
Ad

Advertisements

D

Dave Peterson

Toolbar settings are saved in a file with the extension .xlb.

close excel
Use windows start button|Search
to find all those *.xlb files.
Make sure to look for hidden files and through hidden folders.

Delete them all (or rename them to *.xlbOLD).

Then reopen excel and modify a toolbar (just a few to test)

close excel and reopen it to test it out.

If it worked ok, delete all those *.xlbOLD files.

(I'm guessing you've upgraded through various versions and a couple of *.xlb
files are fighting it out!)

By deleting all the old ones, the "real" one can win.

When you're done making all your real changes, find that file and store a copy
of it somewhere safe--if you need to recreate the toolbar, you can just delete
the *.xlb file and copy the backup into its proper home.
 

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

Top