hi
I try writing macro when I select any cell for any one of them in this range A1:B10 then should pop message and move selection to column C .
this is what I have so far , but doesn't work at all.
I try writing macro when I select any cell for any one of them in this range A1:B10 then should pop message and move selection to column C .
this is what I have so far , but doesn't work at all.
VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("A1:B10")) Is Nothing Then
MsgBox "You have select protected cell " & vbCrLf & "sorry you can't select protected cell", vbInformation, "Kutools for Excel"
Target.Offset(, 1).Select
End If
End Sub