I suppose you could uncheck the "Select Locked Cells" option when you protect
the worksheet. If they can't select the cell, tough to copy it. But there's
always a way around such things in Excel. In this case, without unprotecting
the sheet, they can still select an unlocked cell and then extend the
selection to include the locked cell and perform a copy and paste.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
