Excel Toolbar Layout

  • Thread starter Thread starter CtDMonet
  • Start date Start date
C

CtDMonet

Every morning, when I open Excel, I rearrange the toolbars. How do I save
the arrangement so that I just have to do it once?
 
Al,

Excel saves its toolbar setting in a file named Excel?.xlb, where the ? is a version numbers,
depending on your specific version. You need to have read/write permission to the folder where that
file is stored, so perhaps you don't have the proper permissions. If you do, your problem may be
due to file corruption (a not infrequent occurence, unfortuantely) so try renaming the file - Excel
will re-create it with a fresh version.

HTH,
Bernie
MS Excel MVP
 
Since you mention Toolbars I assume you are not running Excel 2007

In earlier versions Toolbar and Menu customizations were saved in an
Excelxx.xlb file

Perhaps you do not have permission to save that file?

Or it has become corrupt?

Close Excel

Do a search for *.xlb................normally found in

C:\Documents and Settings\username\Application Data\Microsoft\Excel

Rename it then re-start Excel.

It should save a new copy of Excelxx.xlb...............check size.

Re-start Excel

Make a bunch of customizations then quit Excel.

Check size of *.xlb..............should be larger.

Re-start Excel..................did your changes stick?


Gord Dibben MS Excel MVP
 
I tried as you said -- the file did not have a version # (named Excel.xlb).
It created a new file as expected, but it was the same size and didn't
reflect the changes. The only changes I am doing is arranging them in a
better order (covering 3 lines instead of 4). I am using Excel 2000.
 
I have never had 2000 installed but I believe the file name should be
Excel9.xlb for 2000 version.

I would try a search for that and move it to the appropriate folder.


Gord
 
No such luck. The only *.xlb file is "Excel.xlb" If I go in and change
toolbars willy-nilly, rename file to old-excel.xlb (or delete -- I've tried
both), it creates a new file called "Excel.xlb" and places it in the same
folder. When I close & re-open Excel, none of the toolbar changes remain.
 
Wish I had 2000 to test.

Last time I saw just Excel.xlb was version 5.0 or similar.

97(username8.xlb), 2002(excel10.xlb) and 2003(excel11.xlb) all behaved as
they should.

I really have no more for you..............sorry.


Gord
 
Back
Top