Papa
You must use the TAB key to move to unlocked cells on a protected sheet.
Arrow keys or ENTER will go anywhere.
Gord Dibben Excel MVP
On Fri, 22 Apr 2005 10:29:01 -0700, "PapaBear"
wrote:
I am using Excel 2000. I am trying to set a spreadsheet up with protection
such that the cursor will only move to the unlocked cells. The other day
when I unlocked the cells in Cell Format and then protected the sheet this
seemed to work. Now it won't. The cursor can go anywhere. I can only enter
data into the unlocked cells. I can't figure out how to make the cursor move
only to the unlocked cells like it did the other day.
|