Skip to content

Latest commit

 

History

History
46 lines (26 loc) · 1.04 KB

Excel.Window.DisplayHeadings.md

File metadata and controls

46 lines (26 loc) · 1.04 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Window.DisplayHeadings property (Excel)
vbaxl10.chm356084
vbaxl10.chm356084
Excel.Window.DisplayHeadings
7105f3a4-2322-c796-5ca6-59ea46d2e248
05/21/2019
medium

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 

[!includeSupport and feedback]