DisplayFormulas Property

Applies To

Window Object.

Description

True if the window is displaying formulas, or False if the window is displaying values. Read-write.

Remarks

This property applies only to worksheets and macro sheets.

Example

This example changes the active window in BOOK1.XLS to display formulas.


Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
ActiveWindow.DisplayFormulas = True