12/29/2022 0 Comments How to access vba in excel 2016Note that there are many features of the new charts, including waterfalls, which cannot be accessed with VBA, and even with the regular user interface. Here is code recorded while I added a waterfall chart and set three of the bars to totals: Sub Macro1()Ī2(395, xlWaterfall).SelectĪctiveSheet.ChartObjects("Chart 1").ActivateĪctiveChart.FullSeriesCollection(1).SelectĪctiveChart.FullSeriesCollection(1).Points(1).SelectĪctiveChart.FullSeriesCollection(1).Points(1).IsTotal = TrueĪctiveChart.FullSeriesCollection(1).Points(4).SelectĪctiveChart.FullSeriesCollection(1).Points(4).IsTotal = TrueĪctiveChart.FullSeriesCollection(1).Points(7).SelectĪctiveChart.FullSeriesCollection(1).Points(7).IsTotal = TrueĪpplication.CommandBars("Accessibility").Visible = False In the latest Office 365 Insider build, the macro recorder is aware of waterfall charts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |