Article ID: 928980 - Last Review: October 15, 2007 - Revision: 1.2

When you run a VBA macro that animates a chart in Excel 2007, the chart animation may be slower than you expected

Expand all | Collapse all

SYMPTOMS

When you run a Microsoft Visual Basic for Applications (VBA) macro that animates a chart in Microsoft Office Excel 2007, the chart animation may be slower than you expected.

CAUSE

This issue may occur if you select any part of the chart before you run the VBA macro.

WORKAROUND

To work around this issue, add code to the VBA macro. Use the added code to cancel the selection in the chart before the chart animation code runs.

APPLIES TO
  • Microsoft Office Excel 2007
Keywords: 
kbtshoot kbmacro kbchart kbprogramming kbprb kbvba kbexpertisebeginner KB928980
 

Article Translations

 

Related Support Centers