Share via


Window.DisplayHeadings Property

Excel Developer Reference

True if both row and column headings are displayed; False if no headings are displayed. Read/write Boolean.

Syntax

expression.DisplayHeadings

expression   A variable that represents a Window object.

Remarks

This property applies only to worksheets and macro sheets.

This property affects only displayed headings. Use the PrintHeadings property to control the printing of headings.

Example

This example turns off the display of row and column headings in the active window in Book1.xls.

Visual Basic for Applications
  Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
ActiveWindow.DisplayHeadings = False

See Also