Print one-sided and override two-sided default

[Guest]

I have a spreadsheet that must be printed one-sided. I use a long macro
that, at the end, saves to the network and prints the entire workbook. It
worked lovely, until they changed the default settings on all our printers to
two-sided copies.

Is there code to force the spreadsheets to print one-sided? I tried making
a new macro but the print setting didn't get recorded.

This is the current print code:

ActiveWorkbook.PrintOut Copies:=1, Collate:=True

Thanks!
KarenF

 

[green biro]

Would it be possible to insert two page breaks next to each other whenever
you want to page break so that every other page is blank?

Just an idea...

GB