Private Sub Worksheet_Change(ByVal Target As Range)
If Not (Application.Intersect(Range("M13:M200"), Target) Is Nothing) And Target.Count = 1 Then
If Target.Value = "Oui" Then
Sheets("Annexe 3-2").Copy After:=Sheets("Annexe 3-2")
ActiveSheet.Name = [COLOR="Red"]Left(Target.Offset(0, -11).Value,31)[/COLOR]
End If
End If
End Sub