DisplayColumnHeadings Property

Microsoft Office Web Components Object Model

DisplayColumnHeadings Property

       

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