Both Auto_Open and Auto_Activate Macros Run When Sheet Opened (115276)
The information in this article applies to:
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for Windows 4.0a
- Microsoft Excel for the Macintosh 5.0a
- Microsoft Excel for the Macintosh 4.0
This article was previously published under Q115276 SYMPTOMS
In the versions of Microsoft Excel listed above, if a worksheet has both an
Auto_Open and an Auto_Activate macro, both macros will run when that
worksheet is opened.
NOTE: In Microsoft Excel versions 4.0 and earlier for Windows and 3.0 and
earlier for Macintosh, only the Auto_Open macro will run when the worksheet
is opened.
STATUS
This is a known problem in the versions of Microsoft Excel listed at the
beginning of this article. This problem was corrected in Microsoft Excel 97
for Windows and Microsoft Excel 98 Macintosh Edition.
Modification Type: | Minor | Last Reviewed: | 8/15/2003 |
---|
Keywords: | kbmacro kbprb kbProgramming KB115276 |
---|
|