United States (English) Sign in
Home Products Office 365 Docs Samples Downloads Training How To Support Forums
Office and SharePoint development > Office client development > Office 2010 > Excel 2010 > Excel 2010 Developer Reference > Reference > Window Object > Properties > Window.DisplayGridlines Property (Excel)
Office and SharePoint development
Office client development
Office 2010
Excel 2010
Excel 2010 Developer Reference
Reference
Window Object
Properties
Window.ActiveCell Property (Excel)
Window.ActiveChart Property (Excel)
Window.ActivePane Property (Excel)
Window.ActiveSheet Property (Excel)
Window.ActiveSheetView Property (Excel)
Window.Application Property (Excel)
Window.AutoFilterDateGrouping Property (Excel)
Window.Caption Property (Excel)
Window.Creator Property (Excel)
Window.DisplayFormulas Property (Excel)
Window.DisplayGridlines Property (Excel)
Window.DisplayHeadings Property (Excel)
Window.DisplayHorizontalScrollBar Property (Excel)
Window.DisplayOutline Property (Excel)
Window.DisplayRightToLeft Property (Excel)
Window.DisplayRuler Property (Excel)
Window.DisplayVerticalScrollBar Property (Excel)
Window.DisplayWhitespace Property (Excel)
Window.DisplayWorkbookTabs Property (Excel)
Window.DisplayZeros Property (Excel)
Window.EnableResize Property (Excel)
Window.FreezePanes Property (Excel)
Window.GridlineColor Property (Excel)
Window.GridlineColorIndex Property (Excel)
Window.Height Property (Excel)
Window.Index Property (Excel)
Window.Left Property (Excel)
Window.OnWindow Property (Excel)
Window.Panes Property (Excel)
Window.Parent Property (Excel)
Window.RangeSelection Property (Excel)
Window.ScrollColumn Property (Excel)
Window.ScrollRow Property (Excel)
Window.SelectedSheets Property (Excel)
Window.Selection Property (Excel)
Window.SheetViews Property (Excel)
Window.Split Property (Excel)
Window.SplitColumn Property (Excel)
Window.SplitHorizontal Property (Excel)
Window.SplitRow Property (Excel)
Window.SplitVertical Property (Excel)
Window.TabRatio Property (Excel)
Window.Top Property (Excel)
Window.Type Property (Excel)
Window.UsableHeight Property (Excel)
Window.UsableWidth Property (Excel)
Window.View Property (Excel)
Window.Visible Property (Excel)
Window.VisibleRange Property (Excel)
Window.Width Property (Excel)
Window.WindowNumber Property (Excel)
Window.WindowState Property (Excel)
Window.Zoom Property (Excel)
Expand Minimize
This topic has not yet been rated - Rate this topic

Window.DisplayGridlines Property (Excel)

Office 2010

True if gridlines are displayed. Read/write Boolean.

expression .DisplayGridlines

expression A variable that represents a Window object.

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.

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

VBA
Copy 
Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate 
ActiveWindow.DisplayGridlines = Not(ActiveWindow.DisplayGridlines)
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.