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?