Icons/Macros Missing

[David]

Platform: Win XP Pro Sp3.
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.

 

[Gord Dibben]

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

 

[David]

Gord, thankyou for your reply.
I have looked carefully at the .xlb, it was 16kb 2 years ago and still
was16Kb until I wiped it out, restarted at 16kb, changed tools bars, down to
14Kb, but NO the changes to the experimental worksheet did not last. I
probably will use your code to set up a floater, but it appears I have a
deeper problem as Windows Explorer has been giving me minor probs too.
Probably something in permissions/Comodo firewall/AVG - AV, take your pick.

Would you care to point me further as I have never been happy with the
permissions bit in XP as only myself use my couple of machines.
And thankyou again,
Dave.

 

[Gord Dibben]

As far as permissions go I can only point you to Windows Help on that
subject.


Gord