Macro to unfilter all slicer selections (de-select)

[DLE1986]

Can anyone help with the code I need to unfilter all the selections in my slicers on a workbook? I am looking to make all slicer selections NOT selected so the person using the workbook can start from scratch. Would love some help with how to do that via a macro, since excel currently only supports "clearing all filters" and not "unclearing/unfiltering". Thanks!

 

[Misca]

Welcome to the board!

Try something like

Sub ClearSlicerSlections()

Dim SlC As SlicerCache

For Each SlC In ActiveWorkbook.SlicerCaches
    SlC.ClearAllFilters
Next SlC

End Sub