The information in this article applies to:
SYMPTOMSIn Microsoft Excel 97, code that is contained "behind" a worksheet or workbook may not work correctly. CAUSEThis will occur if both of the following conditions are true:
-and- WORKAROUNDIn order for automatically-running subroutines to work correctly in Microsoft Excel 97, they must be contained within a Visual Basic module. To insert a new module:
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATION
In Microsoft Excel 97, Visual Basic for Applications code can be stored in
three different locations: in a Visual Basic module, in a Visual Basic
class module, and "behind" worksheets and workbooks.
If an Auto_Open, Auto_Close, or other automatically-running subroutine is stored "behind" a worksheet or ThisWorkbook, it may not function correctly when you open or close your workbook, or when you perform an action that should cause the subroutine to run. Additional query words: XL97 vbe auto open close
Keywords : kbprg kbdta xlui KbVBA |
Last Reviewed: November 20, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |