Screen updating macro

You can increase the speed of some procedures by keeping screen updating turned off. Insert Paragraph After End With If x Mod 50 = 0 Then Active Document. When screen updating is turned off, toolbars remain visible and Word still allows the procedure to display or retrieve information using status bar prompts, input boxes, dialog boxes, and message boxes. But the screen doesn't refresh, or stops refreshing at some point (e.g. The task eventually completes but the progress bar is useless. For i=1 to imax ' imax is usually 30 or so fraction Done=cdbl(i)/cdbl(imax) Application.

A User Form will not be refreshed in some cases, because Do Events will fire the events; however, Repaint will update the User Form and the user will see the changes on the screen even when another event immediately follows the previous event. The Screen Updating property controls most display changes on the monitor while a procedure is running. Five hundred lines of text are added to the document. How can you turn off the flashing screen during macro execution ?I used this function about 7 years ago and it prevented the user from seeing a bunch of activity while the macro ran.

Leave a Reply