David,
Macros aren't macros unless they reside in Excel spreadsheets:
otherwise, they're just copies of code.
1) Simply email the entire spreadsheet
2) Export the module to a text file, email that, then have the user
import the file
3) Copy and paste the code into the email body, and have the user copy
and paste it into a module
4)...
HTH,
Bernie