Posts by Hablab

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

    Code
    ActiveChart.FullSeriesCollection(1).IsFiltered = True

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

    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