I have been working on a workbook to help my coworker making paperwork faster. In the workbook I made a print button with an "automaticaly built (recorded) macro" to print 8 spreadsheets at the same time. Everybodies printer is sets to print on 2 sides so we should have 4 sheets of 2 pages but I have page 1 on a sheets then page 2-7 on 2 sides sheets and page 8 by itself. Would you know how to fix this?
Code is in "module 11"
Sub PrintRTI()
'
' PrintRTI Macro
'

'
    Sheets(Array("Sheet1_EN", "Sheet2_EN", "Sheet3_EN", "Sheet4_EN", "Sheet5_EN", _
        "Sheet6_EN", "Sheet7_EN", "Sheet8_EN")).Select
    Sheets("Sheet1_EN").Activate
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
        IgnorePrintAreas:=False
        
    Sheets("Sheet1_EN").Select
End Sub
09-ATM-Arriel.xlsm09-ATM-Arriel.xlsm
2015-12-07_10h50_17.png