Nitesh Khot
Member
Hi is there any option to hide pivot table filter but not heading.
Sub removepivotfilter()
Dim pt As PivotTable
Dim pf As PivotField
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
For Each pt In ws.PivotTables
For Each pf In pt.PivotFields
pf.EnableItemSelection = False
Next pf
Next pt
Next ws
End Sub