Clear Filter Macro Triggered by Container Tab Change - Please help

[#1]

Hi, I would appreciate assistance on building a macro that runs when the container tab is changed. The macro would unfilter a specific variable that I can designate. So, if container tab 2 is selected while 1 is on screen, the unfilter macro would run. Thank you and I look forward to your advice. Thanks!

[m_woolf]

There is no event for clicking on a container tab (that I know of).

You might overlay a transparent button on the tabs, and use button actions to do the clear and activate the chart.

[#3]

Hi Mike,

Thanks for the help. I tried implementing some macros I found on the community through the button, but it would not work. Perhaps, I did not change a variable within that factor. I would appreciate your assistance on this. below is the macro I am using:

sub ResetContainerObject

    ContTabSelect0("CT02")

end sub

sub ContTabSelect0(CT02)

    set MV_ContainerObj = ActiveDocument.GetSheetObject(CT02)

    Set MV_ContProp = MV_ContainerObj.GetProperties

    MV_ActiveIndex2 = MV_ContProp.SingleObjectActiveIndex

    MV_ActiveIndex2 = 0

    MV_ContProp.SingleObjectActiveIndex = MV_ActiveIndex2

    MV_ContainerObj.SetProperties MV_ContProp

End Sub

Thank you!