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

Great Idea! Word is a tool to get what you really want—printed output. This means you need to make sure that Word works as well as possible with your printer, whether it is sitting on your desk or in a room down the hall.

Check out WordTips: Printing and Printers today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Printing via Macro without Messages