Standard set up is so that the cursor moves down one row when pressing ENTER. I prefer to change the set up so that the cursor remains in the chosen cell. This is done by de-checking File - Advanced - Editing options - After pressing Enter.

However, when I protect a sheet and de-check "Select locked cells" so that only unlocked cells can be accesses, then it acts as if this standard set up were still valid, i.e. the cursor acts as if I had checked "After pressing Enter, move selection. Direction = Down".

I don't want that. Is there a way to keep the "After pressing Enter" setting regardless of the protection setting?

NSV