Macro for Printing

[Guest]

I set up a macro for a printer because I use multiple
printers in Excel. I want to use the macro on multiple
workbooks in Excel. I want page 1 to print on letterhead
and page 2 to print on plain paper. Sometimes there is
only one page and I want that to print on letterhead. I
put an icon on my toolbar which contains the macro, tt
appeared that the macro was working, however, it prints
either both pages on plain paper or both pages on
letterhead. I think I need to edit the macro, but don't
know the coding to get it right, can any of you excel
experts help me?

 

[Dave Peterson]

I'm not sure what your macro does (tries to change paper bins???).

But it might be easier to create a new printer (same physical printer, same
driver, but with different options).

Then change to the letterhead printer and print just the first page.

The second macro would change to the "normal" printer and print pages 2 (and
on).

I bet recording a macro when you did it would go pretty far in getting it
working (well, after you installed that second driver outside of excel.)

 

[Guest]

Thanks Dave, I'll give this a shot and I am truly grateful
for your response.