Microsoft KB Archive/184093

= XL98: Open Event Macro May Not Activate a Worksheet =

Article ID: 184093

Article Last Modified on 6/17/2005

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q184093



SYMPTOMS
If you create an Open event macro for your workbook, and if the macro contains code to activate a worksheet, the macro is run but the worksheet may not be activated.



CAUSE
The Open event macro may not activate a worksheet if both of the following conditions are true:


 * You create a custom function, either in the workbook with the Open event macro, or in another workbook in memory. -and-


 * Your custom function uses the Volatile method.



RESOLUTION
To resolve this problem, do either of the following:


 * Remove the line of code that contains the Volatile method from the custom function. -or-


 * Use an Auto_Open macro instead of an Open event macro for the workbook.

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. For example, if the Open event macro is the following Private Sub Workbook_Open

Sheet2.Activate

End Sub use the following macro code (on a general module) instead: Sub Auto_Open

Sheet2.Activate

End Sub



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

