Sleeper: Protected sheets and Links?

[cuci]

I am trying to keep worksheets protected and update the source of linked references in cretin unlocked cells.

When I go to LINKS / CHANGE SORCE I can only update (have access to the button) when the sheets are unprotected. I have unlocked the cells and that does not seem to help.

Any advice?

Cuci

[MWE]

I am trying to keep worksheets protected and update the source of linked references in cretin unlocked cells.

When I go to LINKS / CHANGE SORCE I can only update (have access to the button) when the sheets are unprotected. I have unlocked the cells and that does not seem to help.

Any advice?

Cuci

Hi Cuci; welcome to VBAX

I would like to say that it is because you have cretin cells. I am not familiar with cretin cells, but assume that they are stupid and do not do what we want

Seriously, I believe sheet protection is doing what it is supposed to do, i.e., generally protect the sheet from changes. Perhaps others have better insight.

[Ken Puls]

I would like to say that it is because you have cretin cells. I am not familiar with cretin cells, but assume that they are stupid and do not do what we want

[cuci]

Any cell that dos not do what i want it to is a "cretin."

I seem to have found a way around it. It seems that you can change the source of the links in a book even if the links are in a protected sheet if the sheet that is active is unprotected. Strange but it seems true.

Cuci