Private Sub Worksheet_Calculate()
Static maliste
If Range("Cel_MesListes") <> maliste Then
maliste = Range("Cel_MesListes")
Range("Cel_ListeActive") = 1
End If
End Sub
Private Sub Worksheet_Calculate()
Static B2sav As Long
If [B2] <> B2sav Then
[B3] = 1
B2sav = [B2]
End If
End Sub
Sub Zonecombinée1_QuandChangement()
[Cel_ListeActive] = 1
End Sub