:devil2:Code:Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Cells(1, Target.Column) <> "X" Then Target.Offset(0, 1).Select
End Sub
Printable View
:devil2:Code:Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Cells(1, Target.Column) <> "X" Then Target.Offset(0, 1).Select
End Sub
[VBA]Use the VBA button[/VBA]