Removing VBA Code (programatically)

[Marnie R]

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?

 

[Chip Pearson]

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