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

--
Regards,
Tom Ogilvy


"Erin" wrote in message
...
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!