Hi all,

I have created a spreadsheet that creates reports via macro driven database exports and have a series of charts on three different sheets (multiple charts & pages per sheet).

The organisation I work for has all printers defalted to double sided printing however for reporting purposes we are required to print to single sided.

Is there anyway that I can use VBA to override the double sided default or can anyone think of any work arounds?

note: I do not want to replicate the printer as a new printer with different default settings. I am looking for a work around that would work on many different machines.

Cheers,

Pedros.