Platform: Win XP Pro Sp3. is your OS

Which version of Excel are you running?

Sounds like 2003 to me.

Toolbar and Menu customizations in Excel 2003 are saved into a file named
Excel11.XLB

Normally stored here......

C:\Documents and Settings\username\Application Data\Microsoft\Excel

Perhaps this file is not being updated when you close
Excel............permissions not allowing?...............file is corrupt,
can happen when it gets too large.

Close Excel.

Find your Excel11.xlb file and note the modified date and size.

Open Excel with a new workbook.

In Excel make some customizations to Toolbar or Menu.

Close Excel..................has the *.xlb file changed at all?

You may have more than one...........you may have to muck around with
changing names like Excel11.xlb_one or similar.

When you get straightened out make sure you save a copy of your latest.

To avois using the *.xlb file for customizations it would be best to create
toolbars and menus through code in your Personal.xls.

See Debra Dalgleish's site for tips and code for that.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP



On Wed, 23 Dec 2009 02:00:56 GMT, "David" wrote:


I have tried to permanately set new icons up on toolbars. Icons for Macros
which I pull from the "Customise/Macro/ Assign etc" If matters not whether I
Unhide/Hide the Personal.Xls, or whether I simply set up in a common sheet,
etc. The Icons/Macros work like a charm when installed, then I close, saving
etc, saving the Personal.XLS where/if required.
Then bingo, when I restart Excel, the Icons/Macros that I have carefully
installed, simply are not to be seen.
Yes I have accessed as Administrator, just me, or whatever, No luck.
What am I doing wrong??
Oh and a Happy Christmas to one and all!
Dave.