Microsoft KB Archive/928980

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base


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

Article ID: 928980

Article Last Modified on 10/15/2007



APPLIES TO

  • Microsoft Office Excel 2007



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.


Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12

Keywords: kbtshoot kbmacro kbchart kbprogramming kbprb kbvba kbexpertisebeginner KB928980