Microsoft KB Archive/113660

= Resize of Chart Object Not Recorded =

Article ID: 113660

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q113660



SYMPTOMS
When you record a macro using Visual Basic, resizing a chart will be recorded as resizing an active window, not a chart object.



CAUSE
This feature is by design.

The Visual Basic macro is actually recording actions to move or to resize the chart window. This is done by recording movements of the active window (this window holds the activated chart in place within the editing border). While the chart object is being edited, moves and sizes are recorded for the window while the object is tracked underneath. The resulting Visual Basic code appears to be missing some commands, but the recorder is smart about window move/size commands to combine repeated moves and sizes. In other words, if recording actions to make the window larger takes three separate actions, Visual Basic only records one action for the last size moved to.

Additional query words: 5.00 XL

Keywords: KB113660

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.