Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Immuable As Variant
Dim PasTouche As Range
Set PasTouche = Cells(2, 3)
Immuable = PasTouche.Value
If Not Application.Intersect(Target, PasTouche) Is Nothing Then: PasTouche.Value = Immuable: Cells(1, 1).Select
Set PasTouche = Nothing
End Sub
Private Sub Worksheet_selectionChange(ByVal Target As Range)
If Target.Address(0, 0) = "C2" Then Range("A1").Select
End Sub
Private Sub Worksheet_selectionChange(ByVal Target As Range)
Dim c As Range
For Each c In Target
If c.Address(0, 0) = "C2" Then Range("A1").Select
Next c
End Sub