Expand Minimize

Window.DisplayFormulas Property (Excel)

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

expression .DisplayFormulas

expression A variable that represents a Window object.

This property applies only to worksheets and macro sheets.

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

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

Community Additions

ADD
Show:
© 2014 Microsoft