View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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.