Hello,
I want to print certain sheets in a workbook in singel sided and certain sheets in Duplex all in one operation/button.
I cannot find anything on the internet giving a simple code for this. This should however apply to the default printer and not a specific one.
I tried the following but all sheets still come out singel sided:
Code:Sub printpagekjop() ' Print out the Sheets If Duplex = True Then SetPrinterDuplex.PrinterName.Default Duplex = False Sheets("Ordremal").PrintOut Duplex = True Sheets("Kjøpsavtale").PrintOut Duplex = False Sheets("Serviceavtale").PrintOut Duplex = False Sheets("Ordreoversikt").PrintOut End Sub
Any suggestions here would be greatly appreciated![]()




Reply With Quote