Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

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.

↑ Back to the top

Cause

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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB928980, kbexpertisebeginner, kbvba, kbprb, kbprogramming, kbchart, kbmacro, kbtshoot

↑ Back to the top

Article Info
Article ID : 928980
Revision : 3
Created on : 10/15/2007
Published on : 10/15/2007
Exists online : False
Views : 246