Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create a macro that prints to any default printer
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to default the number times a document prints? | Excel Discussion (Misc queries) | |||
members on my network printer not able to print to default printer | Excel Discussion (Misc queries) | |||
excel macro to automatically change default printer | Excel Discussion (Misc queries) | |||
printer prints 1/2 page then ejects | Excel Discussion (Misc queries) | |||
create a pause in print macro to allow user to select printer | Excel Programming |