Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("C:C")) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target.Value = "r"
Application.EnableEvents = True
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C2:C19")) Is Nothing Then
Target.Value = "r"
End If
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Range("C2:C19")) Is Nothing Then
Cancel = True
Target.Value = "r"
End If
End Sub
Pas vu cela dans la demande, mais, au cas où :(...) Pas bête sauf si on veux ensuite comptabiliser les croix (...)
[COLOR="DarkSlateGray"][B]=NB.SI(C2:C19;"<>")[/B][/COLOR]