View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Abdul Abdul is offline
external usenet poster
 
Posts: 35
Default Display of gridlines

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
"Financeguy" wrote:

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.