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.

Note:

If you would like to know how to use the macros described on this page (or on any other page on the WordTips sites), I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.

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

Inserting the Total Number of Pages in Your Document

Word keeps track of many statistics for each of your documents. One statistic is the total number of pages in the printed ...

Discover More

Changing Font Face and Size Conditionally

Conditional formatting does not allow you to change the typeface and font size used in a cell. You can write your own ...

Discover More

Signs Your Computer has a Virus

Think your system might be infected with a virus? How would you know if it was? Here are some quick indicators that your ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

More WordTips (ribbon)

Changing the Default Drive

Macros can be used to read and write all sorts of files. If those files are on a different drive than the current one, ...

Discover More

Counting Words the Old Fashioned Way

One way to specify word count is to count characters and divide by five. If you still need this old-fashioned way of ...

Discover More

Determining If a Number is Odd or Even

Need to know if a number in a macro is odd or even? It's easy to figure out with the simple calculation shown in this tip.

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 five minus 3?

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.