Skip to content

Latest commit

 

History

History
41 lines (18 loc) · 653 Bytes

cddb671b-5b7f-c2a8-1527-bfe0bfdced78.md

File metadata and controls

41 lines (18 loc) · 653 Bytes

Window.DisplayZeros Property (Excel)

True if zero values are displayed. Read/write Boolean .

Syntax

expression . DisplayZeros

expression A variable that represents a Window object.

Remarks

This property applies only to worksheets and macro sheets.

Example

This example sets the active window in Book1.xls to display zero values.

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

See also

Concepts

Window Object

Other resources

Window Object Members