Custom buttons

  • Thread starter Thread starter Svilen Pachedjiev
  • Start date Start date
S

Svilen Pachedjiev

My custom buttons suddenly disappeared.Although my macroses are still in
personal.xls

Could someone help me to bring them back?
 
Svilen

How were the custom buttons created?

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

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
 
The buttons were manualy created, 3 of them were macroses, the others were
selectet buttons for fast access to some common tasks.
My excel10.xlb is 811kb. Is it too large?
I started Excel with him and without him and there were no difference.

The problem started when I updated some links in Word to excel objects, if
that may help to solve the problem.

svilen


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Svilen

How were the custom buttons created?

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

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
 
Back
Top