0

I protected certain cells in the excel worksheet without editing (Using review> Protected sheet) but when I copy the worksheet, locked cells turn into unlocked cells and password is removed.

I want to copy the worksheet in the same workbook into different sheets as well as I want to keep the password without unlocking the cells (editing) even after copying the worksheet. Can I do that Masters???

Improve this question
3
  • Can you just set the two ranges equal? Range([destination range]).Value = Range([original data range]).Value
    – BruceWayne
    Commented Sep 22, 2016 at 17:00
  • Please explain how you 'copy the worksheet'. Protection should be preserved if you copy the entire sheet correctly
    – thilina R
    Commented Sep 22, 2016 at 21:17
  • 2
    Ctrl+A >>>> Ctrl+C >>>> create new sheet >>>> Ctrl+V
    – Pubudu Panapitiya
    Commented Sep 23, 2016 at 19:05

2 Answers 2

Reset to default
-1

There is more than one way to copy.

  • If you use copy and paste for a group of cells, then the protection will not come across.

  • If you right click the tab with the sheet name and select copy, you can copy the entire sheet to another workbook or make another sheet inside the current workbook. This case does preserve the protection meaning it is there and with the original password.

Improve this answer
1
  • 1
    the real problem is I'm not the person who use this after I make this... but I don't now who will. normally people select the entire sheet ( ctrl+A) and copy it. then make the new sheet and press Ctrl+V. in that case protection will disappear. Any way Thank you for giving a new idea.
    – Pubudu Panapitiya
    Commented Sep 23, 2016 at 19:01
-1

Please try this, 1. Copy the cell locked/Protected sheet. 2. Paste on the next sheet or whatever the sheet you want. 3. Right-click the tab button. 4. And hit the "protect sheet" option. 5. Bingo! You will find the cells protected as same in the source sheet.

Thank you,

how to keep on the protection

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .