Custom buttons

S

Svilen Pachedjiev

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

Could someone help me to bring them back?
 
G

Gord Dibben

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
 
S

Svilen Pachedjiev

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
 
Top