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