Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/102337

From BetaArchive Wiki


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



Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.