Duplex printing

**Elvisman** · 09-10-2010, 08:00 AM

Hello,

does anybody know what code I should use for printing duplex in Excel 2007 with VBA? I've been stuck on this for a week so I hope someone knows the answer...

Thank you in advance,

Jeroen Swart

**Domski** · 09-10-2010, 08:08 AM

I've never had to do this myself but one of the suggestions I've seen that made sense was to install a second instance of the printer on your PC with duplex printing set as default and just print to that.

Hope it helps,

Dom

**AnnK** · 09-10-2010, 10:16 AM

Is there a reason why you can't just choose to duplex through your printer controls? I set my default to duplex (note: on a networked printer the company default settings may have primacy. I've found that if I put two spaces before the word 'duplex' when I save the print configuration for the printer, it will be first in the list and so come up automatically- saving me having to choose it everytime.)

**Elvisman** · 09-10-2010, 11:27 AM

There is no reason for it because it's also possible that way. The reason I'm asking this question is because I have a very big Excel file with a lot of sheets. Some of those sheets need to be printed in duplex, are don't. Because of this you need to know the VBA code for setting the printsettings to duplex and back....

But I thank Dom for his advice. Apparently it's just not possible at my computer. I really tried everything. Maybe this is a good 'other' way to do it, so thank you!

Regards,

PS: If someone dóes know the correct VBA code in Excel 2007, I'm still interested...