Dec 19 2021 02:53 PM
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
Dec 19 2021 06:24 PM
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.
Dec 20 2021 03:57 PM
Dec 25 2021 10:03 AM
Dec 25 2021 07:10 PM
Did you apply the Sheet Protection as the last step? Locking cells won't do anything unless the Sheet is Protected.
Dec 26 2021 12:48 PM
Dec 26 2021 03:36 PM
Dec 29 2021 10:34 AM
Dec 29 2021 04:16 PM
SolutionFor 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...
Dec 30 2021 08:24 AM
Dec 30 2021 09:39 AM
You're welcome @ksmith! Glad it is working as desired now.
Nov 30 2022 11:21 PM - edited Nov 30 2022 11:23 PM
Hello. I've a similar situation, but another problem has appeared.
Starting point:
Problem:
Is this behavior comprehensible on your Excel?
You have an idea how to solve it?
Dec 01 2022 02:20 PM
No, my sheet doesn't have this problem.
Is it possible that you have assigned a hyperlink to the entire sheet? I am not sure how you can check this but go to INSERT/hyperlink and click it. you will see a dropdown menu showing all of your hyperlinks. You may have to delete the C23 link and remake it. Worth a try.
will work on this and let you know if I have a fix. Hard to trouble shoot without seeing your sheet.
Dec 01 2022 05:08 PM
When column C is unlocked and all other columns are locked, you cannot select any other cell on the sheet except the cell in column C i.e. the selection will always remain in column C and since column C contains hyperlinks they open when you click on the sheet. And it seems that when you protected the sheet you didn't allow users to select the locked cells.
One way to resolve this is, when you protect the sheet, allow users to select the locked cells so that the selection on the sheet is not always in column C.
Dec 01 2022 09:51 PM
Hello @Subodh_Tiwari_sktneer
This is almost the same what I've thaught initially. And I've tried the following:
I will keep on analysing and post results or questions here
Jun 20 2023 02:34 AM
@GeriD1895 and I created a simple table to reproduce the issue:
Used formatting:
- make it a table
- unlock cells in column B
- protect worksheet with following options:
Now, after having done that, when you click on one of the URLs the page opens as it should. In this example I have tried all URLs. So far so good. However, clicking somewhere outside the formatted table (I tried column AJ first) the last clicked URL opens.
It doesn't seem to work everytime with the same columns. Sometimes URLs open when clicking column U, sometimes URLs open when clicking protected columns in the table.
When opening the Excel table via webbrowser we did not see this behaviour.
This situation leaves us completely puzzled.
Any idea?
Thx
Lutz
Dec 29 2021 04:16 PM
SolutionFor 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...