PDA

View Full Version : Prevent VBA from activating the sheet when it updates a chart.



stanhilliard
12-21-2020, 02:45 PM
I need to examine several different sheets while VBA is running. The VBA periodically updates a chart on one of the sheets. The problem is that when VBA updates the chart the chart's sheet becomes the active one. That often interferes when I am looking at a different sheet. So I want to prevent VBA from activating the chart's sheet when it updates the chart. But I don't want to stop the chart from being updated.