Macro Button Problem

[Squeaky]

I'm having a weird problem on one of my coworkers computer. We have a
spreadsheet we use several marcos on. We created a new macro button on his
toolbar. When we assign the macro to it, it works fine but after closing
excel completely and reopening it, the button remains but the macro link is
missing and needs to be re-connected. All of the other macros work fine, and
it works on all the other PC's using the same spreadsheet/macros. I tried
updating office (2000) but that still didn't help. The macro is in the
personal.xls folder.

Suggestions?

 

[Bernie Deitrick]

Squeaky,

Could be that his Excel?.xlb file is corrupt. Generally, it is found in the filder

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

Move that file to another folder, then restart Excel. Excel will create a new .xlb file, and then
you can go through the same steps of creating the cutton and assigning the macro, and see if it
takes this time.

A better solution is to use code to create the commandbar everytime Excel starts, and assign the
macros etc, then delete it when Excel closes. Lots of code examples in the newsgroups....

HTH,
Bernie
MS Excel MVP

 

[Squeaky]

Hi Bernie,

I moved and renamed the .xlb file and when I opened excel the icons were not
back to default.
I did a search for excel.xlb and found two of them in different locations. I
changed them to .old and 2.old, and moved them to another folder. I opened
excel so it would create a new .xlb in the correct place, then replaced it
with one of the old ones. It is working correctly now.

Thanks for the assistance!