XL97: No Info Window in Microsoft Excel 97 (156450)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q156450

SYMPTOMS

In Microsoft Excel 97, when you click Options on the Tools menu, and then click the View tab, no Info Window option appears in the View tab.

CAUSE

The Info window feature is not available in Microsoft Excel 97. It is not possible to display the Info window by clicking an option or running a macro.

MORE INFORMATION

In earlier versions of Microsoft Excel, the Info window feature allows you to display a window that contains detailed information about the active cell, such as cell formulas, values, format, and protection status. To display the Info window in Microsoft Excel 5.0 and 7.0, use the following steps:
  1. On the Tools menu, click Options.
  2. Click the View tab.
  3. Select the Info Window check box, and then click OK.
You can also display the Info window in earlier versions of Microsoft Excel with a macro command. 
   In this macro language:              Use this command:
   ------------------------------------------------------------------------

   Microsoft Excel version 4.0 (XLM)   =SHOW.INFO()

   Visual Basic for Applications       Application.DisplayInfoWindow = True
NOTE: If you attempt to display the Info window in Microsoft Excel 97 with a macro command, the command does not work, and no error messages appear.

REFERENCES

For more information about the Info window in Microsoft Excel 5.0 or 7.0, click the Index tab in Microsoft Excel Help, type the following text

info window

Double-click the selected text to go to the "Info Window" help topic, and then click the "What happened to the Info Window?" button.
Modification Type:MajorLast Reviewed:10/21/2000
Keywords:kbprb kbui KB156450
©2002 Microsoft Corporation. All rights reserved.