Word.Tips.Net WordTips (Menu Interface)

Including Headers and Footers when Selecting All

Please Note: This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: Including Headers and Footers when Selecting All.

Tim created a simple macro to update all the fields in a template. The macro includes a step that selects the entire document, much like pressing Ctrl+A. This step doesn't select headers and footers, and Tim is afraid that there may be fields to be updated in those locations. He wonders if there is a way to include headers and footers when selecting all, or if there is a different way for his macro to update the fields in the header or footer areas.

The simple answer is that you need to modify your macro code so that it looks in all the different Word areas that there might be fields. The problem with using a "select all" approach is that it only selects text in the main document. Headers, footers, and a host of other elements are maintained in their own separate layers that preclude them from being selected with all the text of the document.

If you simply want to update fields in the main text and in the headers and footers, then you should use a technique such as the following:

Sub MyUpdateFields1()
End Sub

Note that the different layers of a document are referred to as "stories" and maintained within their own collection. While this simple macro very quickly updates the fields in the stories containing the main text, the footers, and the headers, there are other stories (layers) where there could be fields requiring updating. The following macro looks through each story, regardless of its type, and does the requisite updating:

Sub MyUpdateFields2()
    Dim story As Word.Range

    For Each story In ActiveDocument.StoryRanges
            ' Check linked stories as linked stories are not independent
            Set story = story.NextStoryRange
        Loop Until (story Is Nothing)
End Sub

If you really want to be complete, however, there is more than just the different story layers that you need to look through. For instance, it may be that there are some fields contained within text boxes that need updating. A more comprehensive macro is needed to deal with all these other places that fields could be located. In the following example, note the many different elements of the document that can be checked for fields.

Sub MyUpdateFields3()
    Dim doc As Document ' Pointer to Active Document
    Dim wnd As Window ' Pointer to Document's Window
    Dim lngMain As Long ' Main Pane Type Holder
    Dim lngSplit As Long ' Split Type Holder
    Dim lngActPane As Long ' ActivePane Number
    Dim rngStory As Range ' Range Objwct for Looping through Stories
    Dim TOC As TableOfContents ' Table of Contents Object
    Dim TOA As TableOfAuthorities 'Table of Authorities Object
    Dim TOF As TableOfFigures 'Table of Figures Object
    Dim shp As Shape

    ' Set Objects
    Set doc = ActiveDocument
    Set wnd = ActiveDocument.ActiveWindow

    ' get Active Pane Number
    lngActPane = wnd.ActivePane.Index

    ' Hold View Type of Main pane
    lngMain = wnd.Panes(1).View.Type

    ' Hold SplitSpecial
    lngSplit = wnd.View.SplitSpecial

    ' Get Rid of any split
    wnd.View.SplitSpecial = wdPaneNone

    ' Set View to Normal
    wnd.View.Type = wdNormalView

    ' Loop through each story in doc to update
    For Each rngStory In doc.StoryRanges
        If rngStory.StoryType = wdCommentsStory Then
            Application.DisplayAlerts = wdAlertsNone
            ' Update fields
            Application.DisplayAlerts = wdAlertsAll
           ' Update fields
        End If

    For Each shp In doc.Shapes
        With shp.TextFrame
            If .HasText Then
            End If
        End With

    ' Loop through TOC and update
    For Each TOC In doc.TablesOfContents

    ' Loop through TOA and update
    For Each TOA In doc.TablesOfAuthorities

    ' Loop through TOF and update
    For Each TOF In doc.TablesOfFigures

    ' Return Split to original state
    wnd.View.SplitSpecial = lngSplit

    ' Return main pane to original state
    wnd.Panes(1).View.Type = lngMain

    ' Active proper pane

    ' Close and release all pointers
    Set wnd = Nothing
    Set doc = Nothing
End Sub

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (522) 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: Including Headers and Footers when Selecting All.

Related Tips:

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!


Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 5+3 (To prevent automated submissions and spam.)
           Commenting Terms

Comments for this tip:

Rod Galvin    12 Aug 2015, 06:35
Absolute genius, have spent 3 or more days trying to find a solution to updating fields (both in the body and the in the header) of a protected document and the last script works a treat.

I am now about to create the file as a template and hand around to other colleges, hope that it continues to work for all.

Again thank you for solving my problem.
Your Mom    18 Mar 2014, 18:59
I feel very certain there is a keyboard short cut to select everything everything...
Greg Maxey    14 Oct 2013, 13:31
Actually this entire tips page is misleading and incorrect.

It has nothing to do with Including Headers or Footers when "Selecting All" and might more aptly be titled "Update All Fields."

The first macro will is certainly incomplete and will a) result in a compile error if there is no content in either the header or footer and b) won't update fields in the even pages or first page should those settings be applied.

If you "really want to be complete ..." don't use "MyUpdateFields3" either because it also is incomplete.

Add a shape to a header or footer and then add a field to the shape text range. Run the code. The field will not update.

For a more complete macro, see the demo macro here: http://gregmaxey.mvps.org/word_tip_pages/installing_employing_macros.html
Chip Orange    20 Mar 2013, 12:24
I believe the second and third macros need to be combined in order to have one which reliably gets all fields, yet this isn't made clear in the article; is this correct?
Katherine O    11 Jan 2013, 17:56
This (the second one for updating all the story layers) works really well, except that it next page section breaks seem to stop when updating the footers.

Thoughts on fixing this?
DOZE    28 Nov 2012, 11:17
Many thanks about your last macro which seems to work fine

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.