Fail to Copy Worksheet

Frequent Contributor

I am unable to copy worksheets in excel. I got no idea why it happens. The situation is as follows:


I open the excel application and open a new workbook. Everything is fine and I can copy worksheets in the file successfully. However, after I turned to VBA editor, the copy function only produces an empty worksheet.



I am using Excel 2010 (Chinese) + Windows 10 (Chinese). Same problem is also experienced in my company which is using Excel 2016 (Chinese) + Windows 10 (Chinese). 


How can I fix it? Thanks a lot. 

0 Replies