Forum Discussion

MickMick's avatar
MickMick
Copper Contributor
Jan 06, 2021

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

Resources