The information in this article applies to:
SYMPTOMSIn Microsoft Excel 97, when you run a Microsoft Visual Basic for Applications macro that contains the following code:
the value -4167 appears in a message box.
NOTE: When you run the macro from a Visual Basic module sheet in previous versions of Microsoft Excel, the value -4141 appears in a message box. CAUSE
This behavior occurs when the following conditions are met:
-or- The value -4167 appears because the Visual Basic Editor is a separate component of Microsoft Excel 97. MORE INFORMATION
In Microsoft Excel 97, a Visual Basic module sheet is part of the Visual
Basic Editor; and the Visual Basic Editor is a separate component of
Microsoft Excel. So, when you run the macro from the Visual Basic Editor,
the macro returns the value -4167, which indicates that the worksheet menu
bar is displayed.
Additional query words: XL97 97
Keywords : kbdta kbdtacode KbVBA xlwin |
Last Reviewed: November 4, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |