Print one-sided and override two-sided default
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
|