How to copy protection details

  • Thread starter Thread starter jminu
  • Start date Start date
J

jminu

Hi Stefan,

After copying the protected range(this range also contains some cell
which are unlocked and hence are edittable) from Sheet1 I pasted th
same in Sheet2(the master sheet).

Now if I choose Protect Sheet option for Sheet2, the entire shee
including the unlocked cells get protected and hence becom
unedittable.

Is there a way to copy/paste the protection details as is from Sheet1

For the requirement that I have, Move or Copy wouldn't be appropriate

Thanks,
Min
 
First, the original thread is separate from this post.

But I just tried this on a test workbook with two worksheets.

I locked a few cells. I unlocked a few cells.

I protected that worksheet.

I copied a range that included both locked and unlocked cells.

I pasted onto the second worksheet.

I protected the second worksheet.

The cells that were pasted that were locked on sheet1 were locked on sheet2.

The cells that were pasted that were unlocked on sheet1 were unlocked on sheet2.

===
By chance, did you copy|paste special|values.

If you copy|paste the cells, then the format for the cells (including
"lockedness") will get pasted, too.
 
Back
Top