| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Window.DisplayFormulas property (Excel) |
vbaxl10.chm356082 |
|
|
04e75e40-4eb9-93f9-73b2-4024a1c1151d |
05/21/2019 |
medium |
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
[!includeSupport and feedback]