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.

WORKAROUNDS

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.

KBCategory: kbusage KBSubcategory: Additional reference words: 5.00 THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Last reviewed: September 12, 1996 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.