Print Macro for Network Printers

[Henry]

Hi: I built an .xls template form. This form goes all over the company meaning thousands of folks use it and print to hundreds of different printers.

When they hit the Print Button (macro button) I built, I want the Form to print the pre-defined Print Area, and I want it to print at their "default" network printer"--not my printer which could be miles away.

Can someone provide me with the exact VBA I need?

Thanks

MT

 

[Juan Pablo González]

Isn't just this ?

Sheet1.PrintOut

? that should print to the default printer.

 

[Henry]

HI Juan:

I see your posts all the time--good stuff.
I don't know diddly about VBA. Can you provide the entire Code without easily?

MT