Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$4" Then
Application.EnableEvents = False
With Feuil9.PivotTables("Table_tcd").PivotFields("[Tableau3].[REF].[REF]")
.ClearAllFilters
' .CurrentPageName = Target.Value
.VisibleItemsList = Array("[Tableau3].[REF].&[" & Target.Value & "]")
End With
Application.EnableEvents = True
End If
End Sub