DisplayColumnHeadings Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Returns or sets whether column headings are displayed in the specified window. Set this property to False to hide the columns headings. The default value is True. Read/write Boolean.

expression.DisplayColumnHeadings

expression   Required. An expression that returns a Window object.

Example

This example hides the row and column headings in the active window of Spreadsheet1.

  Sub HideHeadings()
   Spreadsheet1.ActiveWindow.DisplayColumnHeadings = False
   Spreadsheet1.ActiveWindow.DisplayRowHeadings = False
End Sub