View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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,