Display of gridlines

[Financeguy]

Is there an easy way of turning off all gridlines in an excel workbook
document (all worksheets) before I execute my vba routine.
Request your help with the syntax.
Thanks in advance.

 

[Abdul]

Sub Test
For Each xwindow In Application.Windows
xwindow.Activate
For Each Sh In ActiveWorkbook.Worksheets
Sh.Activate
ActiveWindow.DisplayGridlines = False
Next Sh
Next xwindow
end sub

====
Please Click YES if this helped you

 

[ryguy7272]

You can also do it by Tools > Options > uncheck Gridlines.

HTH,
Ryan---