Unable to get the Copy property of the Worksheet class

Question

I'm trying to copy a worksheet from workbook into another using Worksheets.Copy function. However, this seem to be working in only some of the files and for others I get "Unable to get the Copy property of the Worksheet class" error message. I've tried to copy/move worksheets manually from other workbooks. Also, tried unprotecting/protecting workbook and worksheets but none seem to be working. I'm using Microsoft Office 2010. Is there an Excel feature that enables/disables copying worksheets form other workbooks?

No, but there's manual workaround. – DataPispor Dec 05 '19 at 13:53 — DataPispor, Dec 05 '19 at 13:53

score 1 · Answer 1 · answered Mar 26 '21 at 07:51

In case someone stumbles upon this in the future, my issue was that the worksheet I was trying to copy was set to 'xlSheetVeryHidden'. To overcome this issue, I temporarily made the sheet visible and made it hidden again straight after the Copy call.

templateWorksheet.Visible = xlSheetVisible
Call templateWorksheet.Copy
templateWorksheet.Visible = xlSheetVeryHidden

score 0 · Answer 2 · answered Feb 08 '17 at 07:26

0

In my case the issue was that I had not been working with the worksheet but the workbook. Make sure you are using the worksheet and not the book.

answered Feb 08 '17 at 07:26

map829

1
1

score -1 · Answer 3 · answered Dec 27 '20 at 08:51

-1

In my case, the Excel file was not enabled for editing. Once I did that, it worked.

answered Dec 27 '20 at 08:51

Jyoti

17
1
1
2

Unable to get the Copy property of the Worksheet class

3 Answers3