XL: Resize of Chart Object Not Recorded

• Microsoft Excel for Windows, version 5.0
• Microsoft Excel for Windows 95, version 7.0

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

Keywords :
Version : 5.00 7.00
Platform : WINDOWS
Issue type :