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