how to hide all table data/make slicer free of filter selection

Dervos

New Member
Joined
Oct 23, 2018
Messages
17
Dear Experts,

I have a large data set in a table - A:G with 13k rows and 6 slicers.

I would like to setup a default view when opening the excel worksheet that would - 1) refresh all data in a table 2) hide all table data/make slicers free of any filter selection.

I also use below vba as a 'reset slicer filters' button. Ideally, I would like it to not only reset the slicer filters but also to return me to the default view - hide all table data/make slicers free of any filter selection.

Code:
Sub ClearMySlicers()
Dim Slcr As SlicerCache
For Each Slcr In ActiveWorkbook.SlicerCaches
Slcr.ClearManualFilter
Next
End Sub

Would someone be able to help me?

Thank you,
D
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,108,817
Messages
5,525,070
Members
409,617
Latest member
Lenaf

This Week's Hot Topics

Top