Forum Discussion
MickMick
Jan 06, 2021Copper Contributor
Macro Alternative in Teams
Hello All,
I have already read this post:
https://techcommunity.microsoft.com/t5/excel/macro-in-teams-alternative/m-p/1412557
In a related question,
Can I achieve clearing all slicers using another function other than VBA code?
I have hosted the file on teams and wish to view the document as a tab rather than open in desktop.
my existing code:
Sub ClearMySlicers()
Dim Slcr As SlicerCache
For Each Slcr In ActiveWorkbook.SlicerCaches
Slcr.ClearManualFilter
Next
End Sub
Thanks for your wisdom.
Hi MickMick
The only way I know how to do this online is by clicking in the Pivot Table, going to the Data Tab and clicking the Clear Button
Wyn
MVP