Copy sheet without macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erin - 23 Jan 2006 15:30 GMT

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 to this Message

Tom Ogilvy - 23 Jan 2006 16:01 GMT

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

Signature

Regards,
Tom Ogilvy

> 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
[quoted text clipped - 3 lines]
> attached to the sheet?
> THANKS!

Reply to this Message

Ron de Bruin - 23 Jan 2006 16:03 GMT

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

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

>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
[quoted text clipped - 3 lines]
> attached to the sheet?
> THANKS!

Reply to this Message