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???
Best Answer
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.