No error at all. it just simply not working. like no respond at all.

When i copy the worksheet in the same workbook, it works. but when i tried to copy it to another workbook, it fails. What i do now, is to highlight the whole worksheet and copy and paste it to the new workbook.