Forum Discussion
Solved
Protected worksheet with specific cells unprotected
I have a family tree worksheet that I want to share with grandkids. there is an Instruction sheet that I want to protect, leaving 3 cells (hyperlinks) that I want the user to be able to click on. P...
For that, you first need to unlock the entire sheet and then lock the cells you want to protect and protect the worksheet itself as a last step in the end. Please follow the points in the screenshot below...
This did not work for me. the cell is still locked.
Sorry for the wrong reply. My reply should be: All cells are still editable. Nothing is locked. Have tried the above fix over and over. Doesn't work for me. I must be missing something or something may be missing in the instructions.
Did you apply the Sheet Protection as the last step? Locking cells won't do anything unless the Sheet is Protected.
- Yes I did...and it still did not work. After sheet protection applied, I could enter text or numbers into any of the cells, including those I did not want to protect (the hyperlinks).