Talvez:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Range("A5:D5"), Target) Is Nothing Then
Application.EnableEvents = False
Target.Offset(-2, 1).Select
Application.EnableEvents = True
End If
End Sub