Window.DisplayFormulas Property (Excel)
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.
Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
ActiveWindow.DisplayFormulas = True