Window.DisplayFormulas Property

Excel Developer Reference

True if the window is displaying formulas; False if the window is displaying values. Read/write Boolean.

Syntax

expression.DisplayFormulas

expression   A variable that represents a Window object.

Remarks

This property applies only to worksheets and macro sheets.

Example

This example changes the active window in Book1.xls to display formulas.

Visual Basic for Applications
Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate ActiveWindow.DisplayFormulas = True

See Also

• Window Object
• Window Object Members