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

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,112,816
Messages
5,542,656
Members
410,566
Latest member
Jonniehoffman
Top