DisplayZeros Property

Applies To

Window Object.

Description

True if zero values are displayed. Read-write.

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