title: VBA print from excel without printing the comments
body: <p>I want to print some of the sheets of a workbook without the extra pages of cell comments being listed.</p>
  
  <p>Done quite a bit of research but have not worked out how to do it</p>
  
  <p>The sub I am using is the following:</p>
  
  <pre><code>Sub PrintAllButtonEvent(control As IRibbonControl)
      Dim theWorksheet As Worksheet
  
     For Each theWorksheet In Sheets
        If Left(theWorksheet.Name, 1) &lt;&gt; "_" Then
           setPrintSize theWorksheet
           UpdateHeader theWorksheet
           theWorksheet.PrintOut
        End If
     Next theWorksheet
  End Sub
  </code></pre>
  
  <p>The PrintOut method does not seem to have an option for suppressing the comments.</p>
  
  <p>I can do it manually by doing the following:</p>
  
  <p>1)File->Print->Page Setup->Sheet</p>
  
  <p>2)Change the Comments drop down to (None) instead of At end of sheet</p>
  
  <p><img src="https://i.stack.imgur.com/Opm8R.jpg" alt="enter image description here"></p>
  
  <p>But I really need to be able to do it from code.</p>
  
  <p>Any ideas? thanks</p>