Excel: WinFax 3.0 Loads Excel Default Worksheet at Startup

Last reviewed: September 12, 1996
Article ID: Q102337

The information in this article applies to:

  • Microsoft Excel for Windows, versions 4.0 and 4.0a

SYMPTOMS

If you are using WinFax 3.0 with Microsoft Excel for Windows, one of the default worksheets will be displayed when you start Microsoft Excel.

CAUSE

The manual for WinFax suggests that you copy one of two macro files to the XLSTART directory, WINFAX1.XLM or WINFAX2.XLM. If you copy either WINFAX1.XLM or WINFAX2.XLM to the XLSTART directory, Microsoft Excel may not be able to load without a default worksheet opening and your Display Options may default to the R1C1 reference style (even if you have a template that specifies the A1 style). This situation occurs because WINFAX1 and WINFAX2.XLM contain an auto-open macro that, by default, displays a new worksheet.

WORKAROUND

To correct the problem, you can edit the auto-open macro as follows:

  1. In Microsoft Excel, if a worksheet is open, choose Unhide from the Window menu. If no worksheets are open, choose Unhide from the File menu.

  2. Select WINFAX1.XLM or WINFAX2.XLM and choose OK.

  3. In either of the files noted in step 2, under HIDE_MACRO_SHEET, remove the =NEW(1) line.

  4. From the Window menu, choose Hide and exit Microsoft Excel.

  5. When you are prompted to save the changes to the file, choose Yes.

If you remove WINFAX*.XLM from the XLSTART directory, you will not experience the problems noted above.

WinFax is manufactured by Delrina Technology, Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

For more information about WinFax, contact Delrina Technical Support at (416) 441-0921.


KBCategory: kb3rdparty
KBSubcategory:

Additional reference words: 4.00 4.00a



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