Private Sub Worksheet_SelectionChange(ByVal R As Range)
Dim plage As Range, cel As Range
On Error Resume Next
Application.DisplayAlerts = False
If Not Intersect(R, Range("e7:e20")) Is Nothing Then
For Each cel In Range("e7:h20")
If R.Offset(0, -1) <> "" Then R.Offset(0, 5) = 1
If ActiveCell.Offset(-1, 0) = "" Or ActiveCell.Offset(-1, 1) = "" Or _
ActiveCell.Offset(-1, 2) = "" Or ActiveCell.Offset(-1, 3) = "" Then
MsgBox "Vous ne pouvez pas modifier cette ligne", vbExclamation, "ATTENTION"
Range(ActiveCell.Offset(0, -1), ActiveCell.Offset(0, 3)) = ""
ActiveCell.Offset(0, 5) = ""
Exit For
End If
Next cel
End If
End Sub