Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$3" And Not IsEmpty(Target) Then
With Sheets("Feuil4").Range("A1").PivotTable.PivotFields("Chef des ventes")
.EnableMultiplePageItems = True
.CurrentPage = Target.Text
End With
End If
End Sub