MACRO FOR PRINTER AND TRAY

kuecker3

New Member
Joined
Feb 21, 2005
Messages
19
I have read other messages and I don't seem to be able to get this to work for me.

I have a single workbook I want to print to other than the default printer. I want all pages of the workbook to print to the lower tray in landscape format.

The printer I want to print to is XeroxPS_103 on Ne01: I want the documents to print to tray 2. I do not want to change the default for all other excel documents and workbooks. I want this to print tabloid.

Now. i can find the vbe, but I don't exactly know how to insert the macro. So I need help with that too.

Thanks is advance.
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,118,084
Messages
5,570,131
Members
412,305
Latest member
Mozz
Top