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???
32 Answers
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.
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,
