Print one-sided and override two-sided default

K

KarenF

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top