This Excel Power Tip will save you and your users time where you create a simple VBA Macro which is assigned to a button you create on your Dashboard and that VBA Macro instantly clears all Excel Slicer filters in the entire Excel Workbook with one single click rather than manually clearing each slicer.
Here is the download link to this Dynamic Excel Dashboard file with an additional instructions tab.
1drv.ms/x/s!Ag...
Enjoy!
Like - Subscribe - Share
------------------------------------------------------------------------------------------------------------------------------------------------------------------
Public Sub Clear_All_Workbook_Slicer_Filters()
' Clears all slicer filters in all worksheets
' Developed by ExcelPowerTips - visit my KZitem Channel - Like - Subscribe - Share
' Switch off screen updating for performance
Application.ScreenUpdating = False
' Declare single Slicer Cache type variable
Dim cache As SlicerCache
' Cycle through each cache in whole Excel workbook and clear any manual filter applied
For Each cache In ActiveWorkbook.SlicerCaches
cache.ClearManualFilter
Next cache
ActiveSheet.Range("D20").Select
' Switch back on screen updating
Application.ScreenUpdating = True
End Sub
------------------------------------------------------------------------------------------------------------------------------------------------------------------
Негізгі бет One Click Clear All Excel Slicers (FREE DASHBOARD DOWNLOAD)
No video
Пікірлер: 27