is there a way to prevent cell selection in columns A,B,D,E (see attached image) WITHOUT using Sheet Protection or WITHOUT using the Worksheet Selection Change below ?
VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim i, j As Integer
i = Target.Row
j = Target.Column
'If Target.CountLarge > 1 Then Exit Sub
Application.EnableEvents = False
If i < 2 Then
Cells(2, 2).Select
End If
If i > 10 Then
Cells(10, 2).Select
End If
If i >= 2 And i <= 10 Then
If j < 3 Then Cells(i, 3).Select
If j > 3 Then Cells(i, 3).Select
End If
Application.EnableEvents = True
End Sub