pour ce qui est des lignes 56,57 et 58, elles faisaient partie de ta demande initiale :
"Les cellules que je souhaiterais traiter sont celles auxquelles j'ai affecté des bordures épaisses : lignes 56, 57, 58, 60, 63, 66, 67, 70, 71, 72"
Voici le code modifié :
Private Sub Worksheet_Change(ByVal Target As Range)
Dim C As Range, Arr, I As Long, MDP As String
MDP = "plomberie"
ActiveSheet.Protect MDP, userinterfaceonly:=True
If Intersect(Target, [S7:MN7]) Is Nothing Then Exit Sub
For Each C In Target
If C.Row = 7 Then
Select Case C.Value
Case "TERMINÉ"
' Cells(56, C.Column).Resize(3).Locked = True
Arr = Array(59, 60, 64, 70, 79, 80, 83, 84, 85, 90)
For I = 0 To UBound(Arr)
If Arr(I) = 90 Then
Cells(Arr(I), C.Column).Resize(, 3).Locked = True
Else
Cells(Arr(I), C.Column).Locked = True
End If
Next I
Case Else
' Cells(56, C.Column).Resize(3).Locked = False
Arr = Array(59, 60, 64, 70, 79, 80, 83, 84, 85, 90)
For I = 0 To UBound(Arr)
If Arr(I) = 90 Then
Cells(Arr(I), C.Column).Resize(, 3).Locked = False
Else
Cells(Arr(I), C.Column).Locked = False
End If
Next I
End Select
End If
Next C
' ActiveSheet.Protect MDP
End Sub
Daniel