I have an extensive workbook which populates using a front page data entry form and prints through command button macros depending on the users requirements.

All worksheets are to be duplex printed which is fine as the default printer is always set to Print on Both sides; however, one of the worksheets needs to be printed duplex but "flip on short edge" is it possible to incoorporate code into my existing code to achieve this and then set the printer back to "flip on long edge"?

This is what I'm using at the moment

Please Login or Register  to view this content.
In this example it is the "Small Licence" worksheet that needs flipping on short edge

Any help will be greatly appreciated

Many Thanks

Ben