title: Printing to Label Printer using Excel Macro
body: <p>I have been working on a macro that needs to print to a label printer instead of the network printer. No matter what I try, it refuses to switch from the default printer to the label printer.</p>
  
  <p>Please take a look at the following code and let me know if you see anything wrong:</p>
  
  <pre><code>Private Sub CommandButton2_Click()
  
  Dim Box As String
  Box = MsgBox("Are you sure you want to print this label " _
  &amp; "?", vbQuestion + vbYesNo)
  If Box = vbNo Then
  Exit Sub
  Else: ThisWorkbook.Worksheets("Label").PrintOut ActivePrinter:="MSP-Label2 on msp-dc-001"
  End If
  End Sub
  </code></pre>
  
  <p>Thanks!</p>