Forum Discussion

WTucker469's avatar
WTucker469
Copper Contributor
Jul 27, 2022

Issue printing Multiple spreadsheets at once

I have a file with 7 separate spreadsheets (tabs) and the 1st and last of which use the 2nd tray of my printer (different color paper). the 5 other tabs print off tray 1.

I can print each individual tab no issue , but when I try to print all tabs at the same time they come out all out of order, and out of the wrong paper source. any ideas?

Macros and VBA

1 Reply

  • ramesh_bh's avatar
    ramesh_bh
    Occasional Reader
    Mar 04, 2026

    G'day mate, I thought i was the only one with similar issue to yours.  It was annoying aye. 

    Issue with my file was that i have 19 separate tabs/sheets and when I'd print mine it would print 11-1 in order and then print 19 to 12.  So id have to swap half pile from front to Back.

    I couldn't create the workbook again because i had mix of raw data and Pictures in them.  Copying the contents from current file into another wouldn't copy the formats of pictures.    

    I tried everything i found online as well and couldn't fix it, in the end what i did was copied my spreadsheets that were printing in wrong order and then deleted the originals.   

    So i copied sheet 19 Infront of 11  then deleted original sheet 19.  Then 18 Infront of 11 and deleted original 18. 

    In the end i copied 11 Infront of  11 and deleted original from them end. 

    Saved changes and tried to print and it printed in correct order. 

    I hope this works for you.

    Regarding the wrong paper source  - Maybe when you copy of the spreadsheet try checking/changing the printing options and see if they take effect.

    I hope this works for you as well.

    Thanks for posting your issue.  All the best.