wilpitz
asked on
Excel printing all workbooks: All worksbsheets need to be simplex but one worksheet needs to be duplex
I have a workbook that I print out 10 worksheets via selecting all the tabs and printing. 9 of these need to be printed out as simplex and the last needs to be printed out as duplex. Is this possible or can I not batch print all of these together.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And here the sample Excel with two buttons (Show printer selection and Print all Sheets):
EEPrintDuplex.xlsm
EEPrintDuplex.xlsm
you can create a macro / VBA code to do this.
For the duplex mode Microsoft released a knowledge base entry because there is no direct built-in property.
Code can be found here:
https://support.microsoft.com/en-us/kb/230743
I have no duplex printer available but I will upload a sample Excel file.
HTH
Rainer