title: How do you prevent printing dialog when using Excel PrintOut method
body: <p>When I use the PrintOut method to print a Worksheet object to a printer, the "Printing" dialog (showing filename, destination printer, pages printed and a Cancel button) is displayed even though I have set DisplayAlerts = False.  The code below works in an Excel macro but the same thing happens if I use this code in a VB or VB.Net application (with the reference changes required to use the Excel object).</p>
  
  <pre><code>Public Sub TestPrint()
  Dim vSheet As Worksheet
  
      Application.ScreenUpdating = False
      Application.DisplayAlerts = False
  
      Set vSheet = ActiveSheet
      vSheet.PrintOut Preview:=False
  
      Application.DisplayAlerts = True
      Application.ScreenUpdating = True
  
  End Sub
  </code></pre>
  
  <p>EDIT: The answer below sheds more light on this (that it may be a Windows dialog and not an Excel dialog) but does not answer my question.  Does anyone know how to prevent it from being displayed?</p>
  
  <p>EDIT: Thank you for your extra research, Kevin. It looks very much like this is what I need.  Just not sure I want to blindly accept API code like that. Does anyone else have any knowledge about these API calls and that they're doing what the author purports?</p>