The information in this article applies to:
SYMPTOMS
In Microsoft Excel, if you use OLE Automation to control another
application, and if you display a dialog box from that application, the
dialog box may not be correctly redrawn when you move it on the screen.
CAUSESDialog Box Is Not Redrawn CorrectlyThis error occurs because of the way in which dialog boxes are handled in OLE Automation. If you display a dialog box from another application, Microsoft Excel is temporarily "frozen" until the dialog box is dismissed. When Microsoft Excel is frozen this way, it does not have the ability to redraw parts of the screen that are occupied by a dialog box, and you may see "ghost" images of the dialog box that only disappear when control is returned to Microsoft Excel. The only solution to this problem is to not move dialog boxes that are shown by OLE Automation.The redraw behavior used by Microsoft Excel is different than that used by Microsoft Visual Basic for Windows, version 3.0. Visual Basic version 3.0 has the ability to redraw parts of the screen, eliminating the "ghost" images, because of the way that Visual Basic handles dialog boxes that are shown by OLE Automation. Microsoft Excel Hangs When a Dialog Box Is DisplayedMicrosoft Excel cannot be accessed when a dialog box called through OLE Automation is still on the screen.If you switch back to Microsoft Excel without dismissing the dialog box, an hourglass will appear and Microsoft Excel will appear to hang. If this occurs, you should switch to the dialog box by pressing ALT+TAB and dismiss the dialog box before returning to Microsoft Excel. Additional query words: lock up freeze doesn't respond
Keywords : kbprg |
|
Last Reviewed: October 22, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |