Print Options via Macro

[smlevron]

I currently have a workbook template that is setup with two tabs and is used to create a file for each day of the week. One tab is oriented in portrait (fit to page), the other is oriented in landscape (fit to page). There is a macro to print the workbook. The problem I have is that it uses two sheets of paper (usually multiple copies), and in the mindset of being a little more eco friendly I would like to print them on a single sheet back and front. Is this possible either via some setting or via some additional code to the existing macro?

Shawn

 

[Andrew Poulsom]

I don't think it's possible to print 2 sheets duplex. In Excel each sheet is a print job.

 

[smlevron]

I don't know if it makes a difference, and I forgot to mention it in the original post. If I go into the printer properties manually, I can elect to print back and front, and set the orientation of each page. Is this something that can only be done manually?

 

[Andrew Poulsom]

It may be possible to do it programatically using the Windows API, but I don't think it will make any difference for the reason I gave you above.

One possibility is to add a third sheet, and copy/paste as picture link each print range, rotating the landscape image by -90 degrees. Then print that sheet duplex with a page break between the 2 images.