How do I create a macro that prints to any default printer

I need a macro that will print a document from any default printer. Here is
the thing... I have created a form and several people will be using the form.
I want to create a macro so that anyone who receives the document can print
the form by clicking a command button Please help thanks

Unless you specifically change the active printer, the macro will print to
the user's active printer.

FYI, You CAN change a printer by using code something like...
Application.ActivePrinter = "hp officejet 6100 series on Ne00:"

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Wanna Learn" wrote:

> I need a macro that will print a document from any default printer. Here is
> the thing... I have created a form and several people will be using the form.
> I want to create a macro so that anyone who receives the document can print
> the form by clicking a command button Please help thanks