The best I can figure is that the worksheet has to be active to turn off the gridlines.
When active you can use:
To find out if a worksheets has its gridlines on or off, again it needs to be active.![]()
ActiveWindow.DisplayGridlines = False
![]()
Dim bOn As Boolean bOn = ActiveWindow.DisplayGridlines
Bookmarks