Forum Discussion
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. Problem is, following MS instructions, I cannot seem to make this work. I enclosing a file of the area. I want to unprotect cells
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...
15 Replies
To do that, select any blank cell and press Ctrl+A to select all cells on the Sheet and then press Ctrl+1 to open the Format Cells window and then go to the Protection tab of that window, uncheck the Lock checkbox and then check it again and click OK to finish. Now go to the Review Tab and click on Protect Sheet under Protect group and provide a password, confirm the password in the next window.
So now the hyperlinks will still work but no one can make any changes on the Sheet.
