VBA does not provide any direct support for selecting the Tray on a printer.

You would have to use the Windows API I believe or perhaps define a separate
print driver that uses tray 2.

--
Regards,
Tom Ogilvy

"jrcruzr" wrote in message
...
I recorded a macro, but it did not include lower bin (tray 2) in the page
setup sequence.
Is there a way to set this program for a particular worksheet?

Thanks,
--
rcruz