expression.DisplayHeadings
expression Required. An expression that returns a Window object.
Remarks
You can use the DisplayColumnHeadings and DisplayRowHeadings properties to independently control the display of column and row headings.
Example
This example hides the row and column headings in the active window of Spreadsheet1.
Spreadsheet1.ActiveWindow.DisplayHeadings = False