Dim pi As PivotItem
With ActiveSheet.PivotTables("Tableau croisé dynamique3").PivotFields("CODE TYPE")
.EnableMultiplePageItems = True
For Each pi In .PivotItems
pi.Visible = Not [A:A].Find(pi.Name, , xlValues, xlWhole) Is Nothing
Next pi
End With
End Sub