Getting rid of multiple macro copies in Excel 2003

5 pts.
Tags:
Excel 2003
Excel 2003 macros
Windows XP
Windows XP administration
Somehow, in Excel 2003 I have 4 copies of the same macro on the toolbar (not sure how that happened).  However, when I click on Tools>Macro>Macros, there are no macros shown, and all options are grayed out except Cancel.  When I go to Tools>Add-ins, one copy of the macro is shown, and it is checked.  How do I remove the copies on the toolbar so that just one is showing?

Software/Hardware used:
Excel 2003, Windows XP
ASKED: April 13, 2010  6:06 AM
UPDATED: April 24, 2010  12:18 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Sounds like a link pointer failure. I am assuming you mean the navigation tool bar not the dropdown tool bar.

If you have used the drag and drop method to add it to the tool bar, it may have been done several times, possibly by other users (assuming more than one person has access to it).

Does the macro still work when it is clicked? I’m guessing it does, hence your question.

Open VBA/macro creation sheet and look through all the macros to see if it is listed there.

Does it work if you click each one in turn? If it doesn’t then remove the ones that don’t work, as it is the link that is broken. Might be why extra buttons were added for the same macro.

Try right click on the macro link in the tool bar and select delete. This should just remove it from the tool bar, but not delete it from the macros list in the vba sheet. You might have to do it for all instances of the macro on the tool bar.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following