Locked Cells / Range Edits / Cell Selection

[nparsons75]

Hi, I have set up various ranges only to be edited by authorised people by adding them to the security within the permissions area. However, When I now click on one of these areas to change and press enter, the cursor (cell surround) jumps and lands on a cell that has no range protection. Does anyone understand why this happens and how to stop it?

 

[Chrisdontm]

It sounds like when you went to apply a password that you "unchecked" the first box of restrictions;

" Select locked cells "

By default that choice is checked.
If you uncheck it, then they will not be able to choose any cells that are locked/protected, only the unprotected cells.

 

[nparsons75]

Hi, thanks for your time and reply. I have already checked that and they are ticked. Both are ticked, select locked and unlocked cells.