Bonjour (..)
Une autre proposition avec le Clic Droit
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Dim celActu As Range
Set celActu = Cells(Target.Row, 1)
If Not (celActu.Value = "") Then
Application.EnableEvents = False
Cancel = True
If celActu.Interior.Color = vbRed Then
Range(Cells(Target.Row, 1), Cells(Target.Row, 10)).Interior.Color = xlNone
Else
Range(Cells(Target.Row, 1), Cells(Target.Row, 10)).Interior.Color = vbRed
End If
Application.EnableEvents = True
End If
End Sub
Sub RazColor()
Range(Cells(4, 1), Cells(Cells(Rows.Count, 1).End(xlUp).Row, 10)).Interior.Color = xlNone
End Sub