Microsoft Excel - Hide Pivot Table Filters Without Hiding Headings
Use a simple VBA macro to hide the native Pivot Table filter controls without hiding the Pivot Table's headings/titles.
File Download Link:
https://www.bcti.com//wp-content/YT_D...
00:21 Old-School Filters for Pivot Tables
00:32 Using Slicers to Filter
03:16 Adding Code to the QAT
03:56 Travelling Custom QAT
04:58 Targeted Filter Control Removal
05:46 VBA Code Examples
UPDATED CODE:
The below code will toggle all filters of the CURRENTLY SELECTED Pivot Table
===========================================================
Sub Toggle_PT_Filters()
' This macro will TOGGLE all filter controls
' for all headings in the SELECTED Pivot Table
Dim pf As PivotField
On Error Resume Next
For Each pf In ActiveCell.PivotTable.PivotFields
pf.EnableItemSelection = Not pf.EnableItemSelection
Next pf
End Sub