Applies To
Window Object.
Description
Sets the information displayed in the Info window (the specified window object must be the Info window).
Syntax
object.SetInfoDisplay(cell, formula, value, format, protection, names, precedents, dependents, note)
object
Required. The Window object.
cell
Optional. True to display the cell reference text.
formula
Optional. True to display the cell formula.
value
Optional. True to display the cell value.
format
Optional. True to display cell formatting information.
protection
Optional. True to display cell protection information.
names
Optional. True to display cell name information.
precedents
Optional. Sets whether precedents are displayed (one of xlNone, xlDirect, or xlAll).
dependents
Optional. Sets whether dependents are displayed (one of xlNone, xlDirect, or xlAll).
note
Optional. True to display notes.
Remarks
If this method is applied to any window other than Info window, an error occurs.
Example
This example displays the Info window and then sets it to display cell reference text and cell name information.
Application.DisplayInfoWindow = True ActiveWindow.SetInfoDisplay cell:=True, Names:=True