I copy specific sheets from one book into a new book but I don't want any VBA code in the new book. One sheet, however, has code in the sheet module. How can I copy it without the code or remove the code in the destination book?

For the copy, I'm simply using...
Sheets(Array(sShtName1, sShtName2, sShtName3, sShtName4)).Copy

Assume sShtName4 has the sheet code.

Thanks,
Melina