Hi,
I am trying to print multiple sheets via a macro, however the printer is printing the worksheets double sided. Is there any way to specify one sided printing and not book setting?
I changed the printer setting to 2 Sided printing as None, but it is still printing double sided.
My code is as follows
Private Sub CommandButton1_Click()
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).PrintOut
End Sub
I am trying to print multiple sheets via a macro, however the printer is printing the worksheets double sided. Is there any way to specify one sided printing and not book setting?
I changed the printer setting to 2 Sided printing as None, but it is still printing double sided.
My code is as follows
Private Sub CommandButton1_Click()
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).PrintOut
End Sub