Microsoft KB Archive/107906

= Microsoft Knowledge Base =

XL5: Find File Opens Add-in as Unhidden and Ignores Auto_Open
Last reviewed: September 12, 1996

Article ID: Q107906

The information in this article applies to:


 * Microsoft Excel for Windows, versions 5.0, 5.0c
 * Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SUMMARY
In Microsoft Excel version 5.0, when you open a file with the Find File feature, it is opened as if you held down the SHIFT key and chose Open from the File menu. The following conditions apply to files that you open this way:

 Microsoft Excel 4.0 add-in files are opened as unhidden editable files. -and- Auto_Open macros or subroutines assigned to the opened files are ignored.

To Open a Microsoft Excel 4.0 Add-in File
To open a Microsoft Excel 4.0 add-in file in Microsoft Excel 5.0 and have it behave the same way it does in Microsoft Excel version 4.0 (that is, the add-in does not appear in a window or the Unhide dialog box), choose Open from the File menu and select the file.

To Run an Auto_Open Macro or Subroutine
If you want to run Auto_Open macros or subroutines when you open files, do either of the following:

- Open the file by choosing Open from the File menu and then select

the file.

-or- - After you open the file in Find File, choose Macro from the Tools

menu. Select the appropriate macro from the list of macros and choose Run.