How to copy sheet to new book without sheet module code?

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

Melina,

To ensure there is no VBA code in the new book, just save it as a .xlsx file. The following could should accomplish what you're looking for:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar