ExcelBanter - VBA line to set to Duplex Printing

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA line to set to Duplex Printing (https://www.excelbanter.com/excel-programming/298320-vba-line-set-duplex-printing.html)

Wingtip

VBA line to set to Duplex Printing

Is there a line for setting printing to Duplex in VBA?

I tried to "record" it, bit it does not appear in the auto
created code.

There is a documented bug in Excel that you need to
manually set each sheet/tab to "duplex". As I have
alomost 100 tabs I wish to avoid doing manually and have
VBA do for me.

Thanks

All times are GMT +1. The time now is 08:03 AM.