ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 326
- Office Version
- 365
- Platform
- Windows
I am trying to hide a certain item from a slicer. I was able to hide it from the pivot table but am unable to remove it from the slicer. Here is the code I used. The Slicer is called "City Name" Help would be greatly appreciated
With ActiveSheet.PivotTables("PivotTable3").PivotFields("Ration Name")
.PivotItems("*New").Visible = False
End With
With ActiveWorkbook.SlicerCaches("Slicer_City_Name").Slicers("City Name")
.SlicerItems("*New").Visible = False
End With