![]() |
Macro for Print
i want to run macro when document send to printer
i tried FilePrint() but my macro executed when the user hit the Print and doesn't show the Print Window to select options then i use FilePrintDefault() this macro executed when the user print through the Default printer if he did't print throught default printer the macro doesn't executed so can i know how to execute the macro when the user click "Ok" button to send to Printer |
Hi sivakl2001,
To intercept the File|Print command and display the print dialogue, use something along the lines of: Code:
Sub FilePrint() |
hi macropod
i need to put my company name in the print out of the all word document page tats why i need this macro ur coding working fine but it print twice this is my code Code:
|
Hi sivakl2001,
Try it this way: Code:
Sub FilePrint() |
Hi Macropod can i create installer for this macro
can u guide me hw to create simple installer for Word Macro |
Hi sivakl2001,
That's outside my field of expertise, sorry. |
Hi sivakl2001,
I see you've been posting about the same question at: http://social.msdn.microsoft.com/For...orddev/threads For cross-posting etiquette, please see: http://www.excelguru.ca/node/7 I don't appreciate finding that I've spent my time helping you to solve a problem only to find that you've had someone else spending their time on the same problem and you haven't bothered to tell either party about the help you've already been given. |
All times are GMT -7. The time now is 06:09 PM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by
DragonByte SEO (Lite) -
vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft