Forum Discussion
Protected worksheet with specific cells unprotected
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...
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.
- 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).