Forum Discussion

Bronze Contributor

Jun 03, 2018

Solved

prevent cursor from going to the headers

I don't want to use sheet protect on the scenario below, as it makes quirky moves... Whenever the cursor moves to any column headers, make it go to or land on range("A2") always. the header is in r...

excel

Macros and VBA

Lorenzo Kim
Jun 03, 2018
I have found an article that solved my query!

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row = 1 Then
Range("A2").Select
End If
End Sub
HOPE THIS WILL HELP OTHERS
MANY THANKS

Lorenzo Kim

Bronze Contributor

Jun 03, 2018

I have found an article that solved my query!

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Row = 1 Then
Range("A2").Select
End If

End Sub

HOPE THIS WILL HELP OTHERS

MANY THANKS