Microsoft KB Archive/930070

= Shape properties in worksheets are not updated correctly in Microsoft Office Excel 2007 =

Article ID: 930070

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Excel 2007

-



SYMPTOMS
When you open a worksheet in Microsoft Office Excel 2007, and you have macros enabled, shape properties may not be updated in a timely manner.



CAUSE
This problem occurs because shape properties are not updated in Excel 2007 until the code that is contained in the macro has run successfully. After the code has run, the shape properties display correctly.



WORKAROUND
To work around this issue, you must add an additional DoEvent function immediately following the existing DoEvent function in the Microsoft Visual Basic code that is contained in the macro.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: XL2007 Excel2007

Keywords: kbtshoot kbprb kbexpertiseinter KB930070

-

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

© Microsoft Corporation. All rights reserved.