Printing all sheets double sided

[mellul]

Hi

I have the following Macro to print all tabs within my worksheet:

Public Sub PRINTALLSHEET()
Dim Sh As Worksheet
For Each Sh In Worksheets
Sh.PrintOut
Next Sh
End Sub

But I would like each page to be printed double sided. Any ideas of what text I would need to add in?

Thanks!

 

[Andrew Poulsom]

Assuming your printer has that option, record a macro while printing a couple of pages manually. That will give you the code.