Updating/Locking FormFields

[Maskot]

Hi,
I need a help with WORD FormFields. I have a document with many formfields and I need to update all fields without two of them. One formfield shows amount in words so the field with this amount earlier cant be updated.
Could you please help? Macro below with problem on red. I need a part that will update each formfield separately.




Sub sbProtectSheet1()
ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True, Password:=""
ActiveDocument.Unprotect Password:=""
ActiveDocument.FormFields("qqq").Result = "XZX"
ActiveDocument.FormFields("wng").Result = "3000"
Dim dFormField As FormField
For Each dFormField In ActiveDocument.FormFields()
If dFormField.Name <> "wng" Then
dFormField.Update
End If
Next
ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True, Password:=""
ActiveDocument.Unprotect Password:=""
End Sub

[macropod]

Why are you using a macro to update the fields, rather than just using their 'Calculate on Exit' property? As for selectively updating, that's only reliable if the fields concerned don't have any dependencies on other fields in the document, since other events, such as printing or previewing the document can also trigger updates.

[Maskot]

I know that I can update/calculate all FormFields at once but in this case I have dependencies between fields and some of them can't be updated. (Field with amount can't be updated after writing in it number because than field with amount in words will broke).
So I need macro that will update specific field or will update all but one or two. Do you know one?

[macropod]

You are mistaken if you believe a field with an amount or text can be updated after writing in it via either the 'Calculate on Exit' property or via a general VBA .Fields.Update method. If someone can write in a Field, it cannot be dependent on any other field. In any event, as I already said:

other events, such as printing or previewing the document can also trigger updates

This applies to auto-updating fields, such as DATE fields and to fields of any kind that reference other fields or document properties.

If your concern is to prevent a field that has already had some kind of user input from being edited, all you need do is change its type property to a 'Calculation' field.

[Maskot]

Yes you are right. Sorry for my mistake (work in a hurry).
You can delete this topic if You want. I have mixed few things.