Since you're only copying one sheet into the new workbook you're attaching, I assume the code you're trying to rid of is in that sheet's class module (event procedures and such)?

I can think of two basic approaches.
Either create a new empty workbook with just one sheet, and then copy over the worksheet's contents and formatting only, instead of copying the whole sheet.
Or copy the sheet as you're doing now, and then delete the contents of its code module - examples here.