Cell entry order in protected sheet

**rselig** · 02-07-2009, 03:37 PM

Is there a way to adjust or select the order in which cells are filled in when the sheet is protected. Word ahs a very option - can excel do the same?
I have seen several VBA's, but not sure how to apply them.
TIA

**mrice** · 02-08-2009, 01:54 PM

You could use an event driven macro to do this.

Paste the following onto the Sheet1 tab in the VBA editor.

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case Is = "$A$1"
    ActiveSheet.Unprotect
    Range("$A$2").Locked = False
    ActiveSheet.Protect
Case Is = "$A$2"
    ActiveSheet.Unprotect
    Range("$A$3").Locked = False
    ActiveSheet.Protect
End Select
End Sub

On Sheet1, lock all the cells except A1 and protect. You will find that A1 to A3 can only now be changed in sequence.

**rselig** · 02-08-2009, 04:41 PM

Thanks very much. Not sure this is what I was looking for. I have unlocked cells - A1, C1, E1 & A3, C3, & E3. When protected you can tab (tab key) from A1 to C1 to E1 then to A3 to C3 to E3. I would like the the cell order to go from A1 to A3 then to C1 to C3 then E1 to E3. I some case I'd like it to move left to right and then sometimes top to bottom. It that possible??
Thanks
Bob