The best I can figure is that the worksheet has to be active to turn off the gridlines.

When active you can use:

ActiveWindow.DisplayGridlines = False
To find out if a worksheets has its gridlines on or off, again it needs to be active.
    Dim bOn As Boolean
    bOn = ActiveWindow.DisplayGridlines