Mike, I have a workbook with multiple sheets. It was created by somebody else who also created an add-in that, among other things, appears to automatically protect all sheets when the workbook opens.
I want to be able to copy data from some of the sheets and paste to another application but with the cells locked and the sheets protected I’m not able to select the data I need. So I created a new sheet and populated it with references (=OldSheet!E12) to the data I need. The plan was to copy from the new sheet. But I couldn’t select data from it either.
So I unprotected the new sheet and unlocked the cells I wanted to copy, then closed, saved, and reopened the workbook. I can now select from the new sheet, but – here’s the problem: I could also inadvertently edit the cells I was attempting to copy. I want to copy but not be able to edit.
Is that clearer?