Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
Me.Unprotect "jojo"
Protect "jojo", UserInterfaceOnly:=True
Application.EnableEvents = False 'désactive les évènements
For Each c In [C6:C7,C9,H6:H7]
c = UCase(c.Formula)
Next
Application.EnableEvents = True 'réactive les évènements
End sub