Hi Tim:

There is no way to do this through VBA. You would probably have to use the
Windows API to manipulate the Printer object.

Regards,

Vasant.

"Tim Gwynn" wrote in message
...
I have a macro that prints to the manual feed tray. I
have the settings in the print setup to automatic select.
Is there a way via the macro to force Excel to print to
Tray 2 or whichever tray I want? I used the record new
macro and changed the paper source that way, but nothing
recorded in the macro. If not possible to force the tray,
is there any other around this.


Thanks.

Tim