Copy Worksheet without VB code attached?
 

Is there anyway to copy a worksheet (with VB code) to a
new workbook without the VB code automatically getting
attached to the copied sheet?

My current code looks like this:
Workbooks(WSNameC).Sheets(aa$).Copy after:=Workbooks
(WSName1).Sheets(aa1$)

Thanks for the advice. This forum is really helpful.

Chris.