XL: Resize of Chart Object Not Recorded

 Last reviewed: September 13, 1996
Article ID: Q113660
The information in this article applies to:
  • Microsoft Excel 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.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00 7.00



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 13, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.