Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / June 2005

Tip: Looking for answers? Try searching our database.

Saving Custom Toolbars in Excel 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MIKE MEDLIN - 07 Dec 2004 19:07 GMT
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
Gord Dibben - 07 Dec 2004 19:53 GMT
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

>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
[quoted text clipped - 3 lines]
>MIKE MEDLIN
>MIKEMEDLIN (remove this)@HOTMAIL.COM
donny808 - 02 Jun 2005 22:22 GMT
> *I want to be able to set my Custom Toolbars to my personal favorit
> settings
[quoted text clipped - 7 lines]
> 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

Dave Peterson - 03 Jun 2005 14:44 GMT
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.

> > *I want to be able to set my Custom Toolbars to my personal favorite
> > settings
[quoted text clipped - 21 lines]
> ------------------------------------------------------------------------
> View this thread: http://www.mcse.ms/message1273681.html

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.