The information in this article applies to:
SUMMARYWhen you apply methods or change properties of a worksheet, the target worksheet may need to be activated before the macro can perform the requested action. If the worksheet is not already active, a brief flash will be noticeable on the screen when the sheet is activated. WORKAROUND
To resolve the problem explained in this article, add the following
line to the beginning of your Visual Basic for Applications macro:
MORE INFORMATION
Some methods and properties that are applied to worksheets will cause
the worksheet to be briefly activated.
Steps to Reproduce Behavior
Some methods or properties, such as the one in the following example, may activate the sheet and cause it to remain the active sheet:
Additional query words: 5.00c
Keywords : |
Last Reviewed: April 8, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |