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

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


"KarenF" wrote in message
...
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