XL97: Code "Behind" Worksheet or Workbook may not WorkLast reviewed: March 16, 1998Article ID: Q157346 |
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:
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 INFORMATIONIn 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. To edit code "behind" a worksheet or a workbook:
|
Additional query words: XL97 vbe auto open close
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |