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...
Hello Subodh_Tiwari_sktneer
This is almost the same what I've thaught initially. And I've tried the following:
- UNLOCK column D (because I don't want to give the users the possibility to click in all cells/columns E, F, G...)
--> same behaviour 😞 - Built a new file with similar columns:
Unfortunately I was not able to reproduce the problem
I will keep on analysing and post results or questions here
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