macro geting separated from worksheet

[Sonoman]

Hi all:
I have a worksheet where I have created a macro. When I email this worksheet
the recipient gets it without the macro. What am I doing wrong? Please
advise.

 

[Ron de Bruin]

Hi Sonoman

Your macro is in a normal module (not in the Sheet module)

The best you can do is to add a button from the Control Toolbox to
the sheet and copy your code in the Click event of the button.

If you mail the sheet now it will send the code also

 

[CLR]

Perhaps you inadvertantly created the macro in your Personal.xls file rather
than the Workbook you are emailing.......

Vaya con Dios,
Chuck, CABGx3