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.
- 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.
