Copy sheet without macro

[Guest]

I have VBA code which will take a copy of the activesheet, save it and create
an Outlook Drafts folder item with the saved workbook attached. My problem
is the original workbook is interactive and has vba code on the
"before_doubleclick" event of the sheet. I do not want the emailed copy to
have this macro code. How can I copy the sheet without copying the macros
attached to the sheet?
THANKS!

 

[Tom Ogilvy]

You can copy the sheet and then clear the macro. See Chip Pearson's site
for sample code

http://www.cpearson.com/excel/vbe.htm

 

[Ron de Bruin]

Hi v

See
http://www.cpearson.com/excel/vbe.htm

My Mail add in have a option to delete the VBA when you send the activesheet.
http://www.rondebruin.nl/mail/add-in.htm