XL:"Cannot find macrofun.hlp" Referencing Analysis ToolPak-VBA

Last reviewed: February 2, 1998
Article ID: Q138888

The information in this article applies to:

Microsoft Excel for Macintosh, version 5.0

SYMPTOMS

In Microsoft Excel 5.0 for the Macintosh, when the Help button for an Analysis ToolPak Visual Basic for Applications library is referenced from the object browser, the following error message appears:

   Cannot find macrofun.hlp. Please select:

The message appears inside of a Find File dialog box. The Macrofun.hlp is the Microsoft Windows version of this help file. The Macintosh version of this file is called "MS Excel Macro Functions Help."

RESOLUTION

To correct the problem, use either of the following methods:

Method 1

When you receive the "Cannot find macrofun.hlp. Please select: dialog box," click the browse button, and select the "MS Excel Macro Functions Help" file in the Excel 5 folder. If you have moved the file, you may need to look elsewhere on your hard disk.

Method 2

Make an alias for the "MS Excel Macro Function Help" file named "Macrofun.hlp" and keep it in the Excel 5 folder.

Additional query words: 5.00 ATP
Keywords : xlmac
Version : MACINTOSH: 5.0
Platform : MACINTOSH
Issue type : kbbug

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: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.