Force doule-sided printing with VBA

[Speshul]

I have a sheet with between 50 and 90 pages (varies daily) that is formatted to print double sided, and am looking for a way to ensure the settings stay on double sided. It seems to work find temporarily...when I set it manually it will print properly, then it stops one day and prints 70 individual pages instead of 35 double-sided pages. I'm guessing that happens when someone tries to manually print just one page instead of using the macro. Anyway...here is what I am using:

Please Login or Register  to view this content.

Thanks!

[GaidenFocus]

This is a printer option, hit CTRL + P and then click Printer Properties. If your printer supports double sided, then it will be an option. it should default to that once the change is made.

[Speshul]

Right, but it does not stay as default because someone is printing individual pages from the sheet instead of using the macros I have in place, which changes the default back to single-sided. What I need is a line of code to force double-sided each time the macro is run to ensure the settings are correct...but I have not been able to find anything :\

[Speshul]

Still having this issue, bump?