Determines whether row headings are displayed in the specified window. Set this property to False to hide the row headers. The default value is True. Read/write Boolean.
expression.DisplayRowHeadings
expression Required. An expression that returns a Window object.
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