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: Locating Locked Fields.
Fields are very useful when working with a document—they allow you to place "dynamic" information in your documents. Sometimes you may want a field to remain static; to not change. You can do this by selecting the field and press Ctrl+F11. This "locks" the field so it does not update from its current value.
If you have a lot of fields in a document, and some of them are locked, you may want a way to quickly find out which ones are locked. Word has no special feature that allows you to search for locked fields, but you can create a macro that will search them out for you. The following macro, FindLocked, starts at the beginning of a document and finds locked fields. It selects each locked field, in turn, and asks you if you want to continue searching.
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: 
Sub FindLocked()
Dim iField As Integer
Dim vResponse As Variant
For iField = 1 To ActiveDocument.Fields.Count
If ActiveDocument.Fields(iField).Locked Then
ActiveDocument.Fields(iField).Select
vResponse = MsgBox("Continue Searching?", vbYesNo)
If vResponse = vbNo Then Exit For
End If
Next iField
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 (1367) 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: Locating Locked Fields.
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!
When merging documents, you may want to include some fields in the merged documents. For some fields this is impossible, ...
Discover MoreIf you try to add a quote mark or a backslash as part of a field parameter or switch, you may be surprised at what you ...
Discover MoreWord allows you to place all sorts of fields in your documents. If you want to search for only specific types of fields, ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
2015-03-13 15:49:19
Paul
I found it, a way to continue.
After the doc.MailMerge and
before the wrdapp.ActiveDocument.Printout
add
If wrdapp.ActiveDocument.Name = "Mail Merge Errors1" Then
wrdapp.ActiveDocument.Close False
End If
and the offending doc disappears.
2015-03-13 15:27:34
Paul
Great macro.
But when I added a line --
ActiveDocument.Fields(iField).Locked = False
it had no effect. Is there a way to automate turning off the Lock?
Or is there a way to suppress the page "Word found locked fields..." from ever printing?
tkx, Paul
Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2018 Sharon Parq Associates, Inc.
Comments