Overiding duplex for entire workbook

  • Thread starter Thread starter Richard Leech
  • Start date Start date
R

Richard Leech

Our HP printers (2300's, 4200's & 5500's) and Toshiba MFD's are set t
print duplex as default. Users can override this default through th
properties option within the printer dialogue box. The problem arise
when a user wants to print an entire Excel workbook as single sided
The user can select print entire workbook and single sided but onl
the current spreadsheet comes off single sided -the other spreadsheet
'not in view' come off as duplex. Simply put, the user wants to be abl
override duplex, select an entire workbook for print and see hardcop
output in line with their requirements.

Any solutions gratefully received
 
Add code to the BeforePrint workbook method which sets
all worksheets to print non duplex.

Steve.

Richard Leech wrote
 
Back
Top