Word does not need to display itself in order to run.
In the above code, you could omit the lines that create and use the Word.
The tasks line up in rows and you simply select yes, no or N/a, for that task for the day on the calendar. Using Personally I would just set the screenupdating property to false without checking it, once the VBA has finished running the screen will update as normal.
Long-running, high-end Excel-based applications that I developed years ago and that run beautifully in Excel 20 look like Amateur Hour in Excel 20 because Application. The screen unfreezes apparently when VBA code copies a preformatted worksheet from the macro workbook into a new workbook, although other circumstances must trigger it as well.Article contributed by Daryl Lucas Many people know they can speed execution of Word Automation by turning off screen updating: Word. Screen Updating = False Many do not know, however, that they can get an even greater speed boost by hiding the application altogether.Here is an example from a Visual Basic client: In the above example, Word launches but does not appear anywhere on the screen. (It does, though, show up in NT's Task Manager, in its list of running processes.) Despite this apparent lack of response, Word is very active and quite capable of doing everything it is told-creating a new document, inserting the message, , saving the file, closing it, and quitting.Many people write their own macros to manipulate their documents.Many times the macro may do quite a bit with the document, such as jumping to different places, replacing text, and taking other types of actions.