Written by Allen Wyatt (last updated June 26, 2018)
This tip applies to Word 97, 2000, 2002, and 2003
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.
Note:
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (576) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Printing via Macro without Messages.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
So, you need to convert a number to text that is over one million? Here is a VBA macro that will convert up to 999,999,999.
Discover MoreThe names you use for macros can affect what you see when you add those macros to a toolbar. This tip explains how you ...
Discover MorePart of developing macros is learning how to use and manipulate variables. This tip examines a technique you can use to ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2023 Sharon Parq Associates, Inc.
Comments