View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Erin Erin is offline
external usenet poster
 
Posts: 75
Default 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!