title: Removing Gridlines in All Charts on All Worksheets
body: <p>I'm working with the following code:</p>
  
  <pre><code>Sub RemoveGridlines()
  
  Dim axs As Axes
  Dim ws As Worksheet
  Dim objCht As ChartObject
  
  For Each ws In Worksheets
          ws.Activate
          For Each objCht In ws.ChartObjects
              With objCht.Chart
                  For Each axs In objCht.Chart
                      .Axes.HasMajorGridlines = False
                      .Axes.HasMinorGridlines = False
                  Next axs
              End With
          Next objCht
  Next ws
  
  End Sub
  </code></pre>
  
  <p>And get hung up on <code>For Each axs In objCht.Chart</code> as an object mismatch. I tried adding <code>.axes</code> to the line but it won't proceed regardless. 
  How can I get this to loop through each axis, chart, and worksheet? Even when I remove<code>.Chart</code> and remove <code>.Axes</code> from the subsequent lines I get <code>Method or data member not found</code>.</p>