Alright, it's working now. Thank you so much for your help. I realized that
when saving the doc as an add-in, the bottom selection is called "Excel 2007
Add-in." That one didn't work, so I used the choice called "Microsoft Office
Excel Add-in." Took me a long time to realize that. :)

Thanks again!

"Gord Dibben" wrote:

Now you go to ToolsAdd-ins and enable the add-in by checkmarking it.

With the sheet of doubled-up email addresses active, just hit CTRL + e and
the macro will run and clean them up.

Note: macros in add-ins will not show up in the ToolsMacroMacros dialog
so must be run via shortcut or assigned to a button or typed into the above
dialog refedit box.

To avoid any potential conflict I would not give the add-in and the macro
the same name.

Easier at this point to change the macro name to something else.


Gord

On Wed, 21 Jan 2009 16:39:01 -0800, dleo
wrote:


Alright, so it's saved as an add-in now. Now what? I don't understand how
saving that allows me to have access to that macro every time I open Excel.
Should I be saving it a certain name or in a certain location? I just named
it the same as the macro name in all caps and put it in the MS Office library.