Window.DisplayHeadings property (Excel)
True if both row and column headings are displayed; False if no headings are displayed. Read/write Boolean.
Syntax
expression.DisplayHeadings
expression A variable that represents a Window object.
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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for