ID: Q113660
5.00 7.00 WINDOWS kbusage
The information in this article applies to:
When you record a macro using Visual Basic, resizing a chart will be recorded as resizing an active window, not a chart object.
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.
KBCategory: kbusage KBSubcategory:
Additional reference words: 5.00 7.00
Version : 5.00 7.00
Platform : WINDOWSLast Reviewed: September 15, 1996