Edit

Share via

Window.DisplayGridlines property (Excel)

  • Article

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)

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.