Removing VBA Code (programatically)
 

I have a massive workbook from which I copy selected
worksheets and email them to a distribution list.

For some of these sheets, there is associated VBA code,
which is needed on the front end (data entry). When I
copy the selected sheets to a new temporary workbook, the
VBA code is no longer needed/useful.

Can I programatically remove the VBA code associated with
these sheets?

Removing VBA Code (programatically)
 

Marnie,

Yes, you can use code to delete existing VBA code. See
www.cpearson.com/excel/vbe.htm for details and example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Marnie R" wrote in message
...
I have a massive workbook from which I copy selected
worksheets and email them to a distribution list.

For some of these sheets, there is associated VBA code,
which is needed on the front end (data entry). When I
copy the selected sheets to a new temporary workbook, the
VBA code is no longer needed/useful.

Can I programatically remove the VBA code associated with
these sheets?