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