Copy sheet without macro
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!
|