what i mean is i would like other workbook to be macro enabled, but it wont copy to that workbook if its macro enabled.The other workbook doesn't need to be macro enabled.
Does it make any difference if you doVBA Code:With ThisWorkbook.Sheets(CStr(i))
It will copy to the other workbook regardless of whether it's macro enabled or not, just make sure you use the correct filename including extension.