macro geting separated from worksheet

  • Thread starter Thread starter Sonoman
  • Start date Start date
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.
 
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
 
Perhaps you inadvertantly created the macro in your Personal.xls file rather
than the Workbook you are emailing.......

Vaya con Dios,
Chuck, CABGx3
 
Back
Top