Skip to content

Latest commit

 

History

History
45 lines (26 loc) · 1 KB

Excel.Window.DisplayGridlines.md

File metadata and controls

45 lines (26 loc) · 1 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Window.DisplayGridlines property (Excel)
vbaxl10.chm356083
vbaxl10.chm356083
Excel.Window.DisplayGridlines
d4253c7f-bed2-6e58-9b04-479355f70561
05/21/2019
medium

Window.DisplayGridlines property (Excel)

True if gridlines are displayed. Read/write Boolean.

Syntax

expression.DisplayGridlines

expression A variable that represents a Window object.

Remarks

This property applies only to worksheets and macro sheets.

This property affects only displayed gridlines. Use the PrintGridlines property to control the printing of gridlines.

Example

This example toggles the display of gridlines in the active window in Book1.xls.

Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate 
ActiveWindow.DisplayGridlines = Not(ActiveWindow.DisplayGridlines) 

[!includeSupport and feedback]