Thisworkbook :
Public msValeurSave
Private Sub Workbook_Open()
SumEfficience = Sheets("Sheet1").Application.Sum(Range("Q4:Q100"))
TriEfficience
End Sub
Sheet1:
Sub Worksheet_Calculate()
SumEfficience = Application.Sum(Range("Q4:Q100"))
If SumEfficience <> msValeurSave Then
TriEfficience
msValeurSave = SumEfficience
End If
End Sub