Edit

Share via

Window.DisplayFormulas property (Excel)

  • Article

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.