Display of gridlines

  • Thread starter Thread starter Financeguy
  • Start date Start date
F

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.
 
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
 
Back
Top