Hi all,

Going to try to explain this to the best of my ability...

We have alot of excel workbooks that have multiple tabs. To print those tabs our admin staff usually shift + selects the ones they want to print. we have printers with different trays and papertype (plain paper and letterhead) Our problem is that you can pick the tray / papertype for the selected tabs BUT this only changes the active tab AKA the one selected first.

the paper type seems to be handled by the print driver and not excel however I'd like to know if theres anyway in excel to force it to take a certain paper type. I thought I'd ask here first before building a macro to do it for me. any input would be greatly appreciated, thanks!

John.