Forum Discussion
ksmith
Dec 19, 2021Brass Contributor
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...
- Dec 29, 2021
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...
ksmith
Dec 29, 2021Brass Contributor
o.k. I must have missed the last "lock" detail. However, how do I just protect ONE section of worksheet, and not the entire sheet?
Subodh_Tiwari_sktneer
Dec 29, 2021Silver Contributor
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...