share a macro with others

Unless all the recipient users are experienced users who could copy a text e-mail of the VBA macro into a module in their own personal.xls, the simplest way that comes to mind is to convert that macro into an addin (File\Save As|Microsoft Excel Addin (*.xla). Then e-mail them the Addin and Although the procedure is not directly accessible to the user as it is in a normal workbook, you can access use direct methods such as giving it a shortcut key when you create it which the user can use to activate it, or you could include a toolbar or menu option in the nmacro which they would have access to. Further, if they know the name of the procedure in the addin they can enter it directly into the Macros dialogue box and click run to execute it.
After you create the addin, e-mail it to them and have them save it somewhere appropriate such as the Excell subdirectory. Then they need to load it by going to Tools\Addins\ and then selecting it from the list. If it is not shown on the list, click browse and find the XLA file - then it will be on the list.

Unless all the recipient users are experienced users who could copy a text e-mail of the VBA macro into a module in their own personal.xls, the simplest way that comes to mind is to convert that macro into an addin (File\Save As\Microsoft Excel Addin (*.xla). Then e-mail them the Addin and although the procedure is not directly accessible to the user as it is in a normal workbook, you can access using direct methods such as giving it a shortcut key when you create it which the user can use to activate it, or you could include a toolbar or menu option in the macro which they would have access to. Further, if they know the name of the procedure in the addin they can enter it directly into the Macros dialogue box and click run to execute it.
After you create the addin, e-mail it to them and have them save it somewhere appropriate such as the Excel subdirectory. Then they need to load it by going to Tools\Addins\ and then selecting it from the list. If it is not shown on the list, click browse and find the XLA file - then it will be on the list.

Thanks Glen. They are not experienced users at all, in fact, most don't even use the most basic autsum functions to add cells up. So the simplest way to get them the macro, the better.
Question for you: How do I get the 'save as' function to appear? I opened the macro in VBA but I don't get save as as an option. Should I do another step first? I'll let you know how your suggestion works once I can save the darn thing as an .xla.

I'm trying but no luck/SOS/receiving bad error messages

Glenn: Here's what I've been doing:
Opened macro in VBA. Exported file. Selected 'save as', to C:\program files\microsoft offic\office\library.
clicked send to, sent to a likely candidate nearby.
Opened e-mail, selected 'save to disk' when prompted, then saved to the other person's C:\program files\microsoft offic\office\library.
Went to Excel. Opened book 1, clicked tools, selected 'add ins'. not showing on list, so did browse. Found file, received big red X error: "macro24 is not a valid add-in". Ideas?
Thanks again for your help and insight. EB

Re: I'm trying but no luck/SOS/receiving bad error messages

You have probably exported the module.
You just need to save the file as an addin;
Goto file | saveas | select addin

Ivan