1. Highlight all the cells on your worksheet that you’re interested in.2. Right-click and select Format Cells3. Select the Protection tab4. Un-check the "Locked" option (this will enable editing for all cells)5. Click OK6. Now, select the cell that you DO NOT want edited7. Right-click and select Format Cells8. Select the Protection tab9. Check the "Locked" option (this will lock the cell from being edited)
Now, we need to protect the sheet:
1. Click the Tools menu2. Select Protection3. Select Protect Sheet4. Type in a password and Unprotect the sheet.5. Click OK6. Confirm Password
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?