XL97: No Info Window in Microsoft Excel 97

ID: Q156450


The information in this article applies to:
  • Microsoft Excel 97 for Windows


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.

Additional query words: XL97 97 8.0

Keywords : kbui xlui xlminfo
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: November 4, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.