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