Protected worksheet with specific cells unprotected

Hi Subodh_Tiwari_sktneer ,

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

Hello Subodh_Tiwari_sktneer 

This is almost the same what I've thaught initially. And I've tried the following: 

1. 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 😞
2. 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 

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.

GeriD1895 

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.

Subodh_Tiwari_sktneer 

Hello. I've a similar situation, but another problem has appeared. 

Starting point: 

• Column C containts hyperlinks
• Column C "UNLOCKED" as mentioned by you, all other columns are "LOCKED"
• Protect Sheet

Problem:

• When clicking on the first hyperlink -let's say C19- everything works fine
• When clicking somewhere else on the sheet, the hyperlink from C19 opens again (Hyperlink remains somehow in a cache?)
• Only clicking on another hyperlink -e.g. C23- changes behavior
• But it starts again with the hyperlink from C23, no matter where you click on the protected sheet

Is this behavior comprehensible on your Excel?

You have an idea how to solve it?

You're welcome ksmith! Glad it is working as desired now.