[djjones]

I have a small table in a WORD form with a simple formula that I would like
to have automatically calculate for the end users. The formula is SUM(above).
I don't want the users to have to lock & unlock the form, but can not figure
out a macro to unlock, calculate the SUM or insert the formula, and re-lock
the form. The macro stops recording as soon as I click the lock form button.
Also, can I create a "button" within the form for the macro? Any
suggestions? Thank you.

[Suzanne S. Barnhill]

You don't need a macro to update the field. Calculated fields in protected
documents update automatically provided (a) "Calculate on exit" is checked
for each form field that contributes to the calculation, and (b) users tab
out of the fields (a proper "exit") rather than just click elsewhere.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"djjones" wrote in message
...
I have a small table in a WORD form with a simple formula that I would like
to have automatically calculate for the end users. The formula is
SUM(above).
I don't want the users to have to lock & unlock the form, but can not
figure
out a macro to unlock, calculate the SUM or insert the formula, and
re-lock
the form. The macro stops recording as soon as I click the lock form
button.
Also, can I create a "button" within the form for the macro? Any
suggestions? Thank you.