Hi Gord
Thanks for assistance
Tried to change the menubar on my computer
cannot press the reorganizebutton (grey)
Cannot find any XLB file
Will do same on my home computer
will revert with results
Best regards
Ron
Gord Dibben schreef:
Ron
Menu and Toolbar customizations are stored in your Excelx.xlb file
"x" is a version number like 9 for 2000, 10 for 2002 and 11 for 2003.
If it gets too large, it can become unstable.
Or perhaps if on a network, Excel is confused about where to store it.
Or you do not have permission to save to the folder where *.xlb is stored.
Do a search for this file. There could be more than one *.xlb file so may have
to check all copies to see which is loading.
Usually stored in..................
C:\Documents and Settings\username\Application Data\Microsoft\Excel
When found, first rename the *.XLB file to *.OLD file. Note the size of this
file in kb.
Now close out Excel then re-open.
Make a few minor changes to a menu or toolbar then close Excel.
Does Excel create a new *.XLB file?
Is it basically the same size as the *.OLD file?
Reopen Excel. Have your changes stuck?
Gord Dibben MS Excel MVP
On 5 Oct 2006 12:54:20 -0700, wrote:
Hi
Please help
I like to edit the menubar
by opening tools customize commands reorganize
I can choose the menu I like to change on top
modify selection
rename the name
and close
save
as long I do not close the program it works fine
after closing and startup the program again the menubar has not been
saved
what do I wrong ??
Thanks in advance for your prompt reply
Best regards
Ron
Gord Dibben MS Excel MVP