how to set Field update setting to Manual

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

musicgold - 30 Jan 2008 16:26 GMT

Hi All,

I am trying to use VBA to set the links in a Word doc to the Manual Update
setting.
I copy a table ( linked to another Excel doc) in this word doc and want to
set the fields to update only when I right click on the table and hit 'Update
link'. I not able to get my macro set the radio button in front of the Manual
update field. The code is given below. Please give some suggestions. Thanks.
MG.

Public Sub UpdateAllLinks()

' to make all links in the word document update only manually

Dim oFld As Word.Field

For Each oFld In ActiveDocument.Fields
If oFld.Type = wdFieldLink Then

With oFld
'.Locked = True ' this line locks the field. I can not manually update the
field.

End With

End If
Next
End Sub

Reply to this Message

Doug Robbins - Word MVP - 31 Jan 2008 11:37 GMT

Maybe this will do what you want:

Application.Options.UpdateLinksAtOpen = False

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi All,
>
[quoted text clipped - 28 lines]
> Next
> End Sub

Reply to this Message

musicgold - 01 Feb 2008 01:57 GMT

Doug,

Thanks. However setting that option will affect the whole workbook.
I am trying to set the manual update option only for the fields linked to an
Excel file.

>Maybe this will do what you want:
>
[quoted text clipped - 5 lines]
>> Next
>> End Sub

Reply to this Message

Stefan Blom - 04 Feb 2008 09:49 GMT

Have you tried to *lock* the individual field, using Ctrl+F11 (you can then
use Ctrl+Shift+F11 to unlock the field).

Note that not all fields supports locking, though. For example, EMBED fields
do not.

Signature

Stefan Blom
Microsoft Word MVP

> Doug,
>
[quoted text clipped - 12 lines]
>>> Next
>>> End Sub

Reply to this Message