Printing via Macro without Messages

Summary: When you are printing a document, it is not unusual to see messages (dialog boxes) periodically. When you want the printing to be done by a macro, the messages can cause unwanted interruptions. Here's a way to make the messages stop. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)

Vidar is trying to print a Word document by automation. When printing, Word interrupts the print job, displaying a dialog box that indicates the document is too wide for the selected printer and asking if it should be printed anyway. Vidar wonders if there is a way to suppress this notification programmatically and always print anyway.

Perhaps the easiest way is to simply turn off notifications just before you start to print. Simply add this line to your macro:

Application.DisplayAlerts = False

This turns off the alerts (in this case, the unwanted dialog box). You can later, after the printing is done, set the DisplayAlerts property back to True so that regular notifications occur.

Tip #576 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

Document and Annotate! One of the easily overlooked tools provided by Word is the ability to add footnotes and endnotes to your documents. WordTips: Footnotes and Endnotes is the definitive resource guide to using these tools to enhance your documents.

Check out WordTips: Footnotes and Endnotes today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Printing via Macro without Messages