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.
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!
One of the more esoteric ways to display data is with an "array," which is like a miniature inline table. This tip ...
Discover MoreTemplates are a powerful part of the Word experience, as they allow you to create and format documents based on patterns. ...
Discover MoreThe DATE field is one of the most commonly used fields for placing dynamic information in your document. It is helpful to ...
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 © 2017 Sharon Parq Associates, Inc.
Comments