Run macro after .IsFiltered = True function

  • Is it possible to have a macro automatically run while a chart is activated and the following line appears?

    ActiveChart.FullSeriesCollection(1).IsFiltered = True

    If so, how should it be written so that it runs the following code:

    Sub Macro1()
        ActiveSheet.ChartObjects("Chart 1").Activate
        ActiveChart.FullSeriesCollection(6).IsFiltered = True
        Application.Run "CountTest.xlsm!getYAxisMax"
        ActiveChart.FullSeriesCollection(6).IsFiltered = False
    End Sub

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!