Excel 2003 customize toolbar command lost
Alex
Could be your *.XLB file is corrupt..............can get this way if overly
large from too many customizations or just for fun<g
Close Excel.
Look for your Excel11.XLB file which stores customizations to toolbars and
menus.
Usual storage is........................
C:\Documents and Settings\username\Application Data\Microsoft\Excel
Rename it to Excel11.xlbold then re-start Excel, which will give you a new
Excell11.xlb file as default.
Note the size of this file.
Make a few minor changes to a Toolbar or Menu then close Excel.
Check the Excel11.xlb file size........any change?
Open Excel..........have your latest customizations stuck?
Gord Dibben MS Excel MVP
On Tue, 10 Apr 2007 13:44:01 -0700, Alex wrote:
Recently my Excel does not keep customize toolbar commands (like paste
special value). Once excel is close and re-open, the customized commands
dissappeared.
thanks,
|