| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy sheet without macro
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy sheet without macro
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 -- Regards Ron de Bruin http://www.rondebruin.nl "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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro - copy/add to another sheet | Excel Discussion (Misc queries) | |||
| Macro to copy a sheet and name it | Excel Discussion (Misc queries) | |||
| Macro to copy sheet(s) | Excel Programming | |||
| Macro to copy sheet | Excel Programming | |||
| How to create a Macro to Copy Information in one sheet to another sheet. | Excel Programming | |||
Linear Mode
