Macros can live in workbooks, add-ins or perhaps in your Personal.xls

Try ToolsMacroMacros.

Does the macro name appear in the list?

If so, hit the "Edit" button and copy the macro then paste it into the body of
the email.

If it doesn't appear in the list it could be a Private Sub or lives in an
add-in.

In that case, hit ALT + F11 to open the Visual Basic Editor.

You will have to browse through the Projects and find the module with the macro.

There are several ways to export......copy/paste the macro.

Export the entire module as a *.bas file which you can attach to an email.

The receiver would have to import that *.bas file into a workbook.

Too many ways to do this..........the above is just a couple.


Gord Dibben MS Excel MVP

On Fri, 20 Jan 2006 08:48:01 -0800, "Bruce"
wrote:

I am trying to email a macro from Excel in Office 2000 Professional. Where
do I look in Excel to find the macro to attach it to an email?