macro geting separated from worksheet

S

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.
 
R

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
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top