![]() |
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 |
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 |
All times are GMT +1. The time now is 05:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com