Macro to clear all slicers except one

[brookep5842]

Hello, I'm working with a table with many slicers. I want a command button that will clear all the filters from the slicers, but keep the 'year' slicer as is. Any help would be appreciated. I'm quite new with VBA, so please make it really obvious what parts of the code I should be substituting with my own slicer names ect, and what I should copy exactly.

Thank you^^"

 

[severynm]

Welcome!

The filter state a specific slicer are stored in its SlicerCache object, which in turn is part of the Workbook. What that means, is for each slicer in the current workbook to clear the filters on, you would want to use

ThisWorkbook.SlicerCaches("Slicer_Field").ClearAllFilters

, with Field being the name of the field assigned to that slicer.

 

[brookep5842]

Welcome!

The filter state a specific slicer are stored in its SlicerCache object, which in turn is part of the Workbook. What that means, is for each slicer in the current workbook to clear the filters on, you would want to use

ThisWorkbook.SlicerCaches("Slicer_Field").ClearAllFilters

, with Field being the name of the field assigned to that slicer.

Thank you! It worked great