Please Note: This article is written for users of the following Microsoft Word versions: 2007 and 2010. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Controlling Repagination in Macros.

Controlling Repagination in Macros

by Allen Wyatt
(last updated December 7, 2013)

1

Ken asked if there is a way to turn off automatic repagination of a Word document while a macro is running. It turns out, in fact, that there are two ways you can handle this.

The first method is use the Pagination property of the Options object. You can set this property to either True or False, as follows:

Options.Pagination = False

This property is the same as setting the Enable Background Repagination option in the General sectiono f the Advanced options (in the Word Options dialog box). If the property is set to False, then Word does not perform any background repagination. You can later set the property to True to turn the feature back on.

The second method for handling automatic repagination is to simply turn off screen updating. If your macro does quite a bit of slicing and dicing on the document, this is always a good idea, anyway, as it stops Word from trying to update the display. In some cases, the speed improvement for your macro can be dramatic if you turn off screen updating. You control screen updating in this manner:

Application.ScreenUpdating = False

Again, the ScreenUpdating property can be set to either True or False. If set to False, screen updating is turned off. If you turn it off, you should always set ScreenUpdating to True before ending your macro.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (9233) applies to Microsoft Word 2007 and 2010. You can find a version of this tip for the older menu interface of Word here: Controlling Repagination in Macros.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Copying and Moving Footnotes

Want to get your footnotes from one place to another in a document, or even from one document to another document? It's easy ...

Discover More

Defining Shortcut Keys for Symbols

Do you need to use symbols frequently in your Excel data? The common way to insert them is by using the Symbol dialog box. ...

Discover More

Determining the Name of the Day of the Week

What day of the week is that date? Sheets can let you know by using the TEXT function to return a weekday name for a ...

Discover More

The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2013. Spend more time working and less time trying to figure it all out! Check out Word 2013 For Dummies today!

More WordTips (ribbon)

Displaying Properties Dialog Box in a Macro

Word keeps track of identifying and statistical information about a document and makes that information available in the ...

Discover More

Cleaning Up Text in a Macro

Need to remove extraneous characters from a text string? VBA makes it easy through the CleanString method, described in this ...

Discover More

Deleting a Macro

ScreenTips can appear with or without shortcut keys displayed in them. Here's how to control whether they appear or not.

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 6 + 0?

2014-05-14 11:38:26

Chris Canada

Hello Allen,

I wanted to let you know your tip above helped significantly in an issue we were having. We were turning off pagination when assembling the document from separate RTF files and then turning it on again before document load. This seems to have caused an increase in elapsed time to open the document with each new document. We use Word to edit medical cases and transcription occurs in each case.) Removing the pagination setting made the elapsed time at least constant.

Our setup is rather interesting. We have a custom ribbon for call backs to our application that uses some XML in a dotm file and some ini info from the application. The settings are split due to variances between cases. We have a macro that assembles the document to be displayed. The document is assembled from several RTF documents that contain medical detail.

What I'm seeing happen is most of the macro takes less than a second to run. The creation of the custom ribbon kicks off and seems to halt everything for 15 seconds. After the 15 seconds the macro completes and returns control to the application which then opens the assembled document.

My question to you is, have you seen anything like this?

Thank you for taking the time to read my post and I hope to hear from you.

Chris


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.