DisplayHeadings Property
True if both row and column headings are displayed, False if there are no headings displayed. Read/write Boolean.
Remarks
This property applies only to worksheets and macro sheets.
This property affects only displayed headings. Use the PrintHeadings property to control the printing of headings.
Example
This example turns off the display of row and column headings in the active window in Book1.xls.
Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
ActiveWindow.DisplayHeadings = False