Re-Bonjour
Je pense avoir trouvé
Si quelqu'un à une solution plus simple, je suis preneur.
If Not Intersect(Target, Range("B:B")) Is Nothing And Target.Count = 1 Then
With Target.Offset(0, 1).Select
Target.Locked = True
End With
End If
If Not Intersect(Target, Range("C:C")) Is Nothing And Target.Count = 1 Then
With Target.Offset(0, 1).Select
Target.Locked = True
End With
End If
If Not Intersect(Target, Range("D:D")) Is Nothing And Target.Count = 1 Then
With Target.Offset(0, 1).Select
Target.Locked = True
End With
End If
If Not Intersect(Target, Range("E:E")) Is Nothing And Target.Count = 1 Then
With Target.Offset(0, 1).Select
Target.Locked = True
End With
End If