SHOW.INFO

Macro Sheets Only

Controls the display of the Info window.

Syntax

SHOW.INFO(logical)

Logical controls the display of the Info window.

• If logical is TRUE, Microsoft Excel switches to the Info window.
• If the current window is the Info window and logical is FALSE, Microsoft Excel switches to the workbook linked to the Info window.

Tip Before using SHOW.INFO, use ACTIVATE to switch to the workbook you want information about and SELECT or FORMULA.GOTO to select the cell or range you want information about.

Remarks

The Info window is not available when a chart is active. If SHOW.INFO is carried out when a chart is the active sheet, an Info window will be displayed for the worksheet or macro sheet that was most recently active.

Related Function

FORMULA.GOTO Selects a named area or reference on any open workbook

GET.CELL Returns information about the specified cell

SELECT Selects a cell, worksheet object, or chart item

List of Command-Equivalent Functions