Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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!