[Renato - Brazil]

I created a form in which numerical inputs, placed in collumns, will be
calculated with a formula placed in the last collumn. When I protect the
form, to limit users to only access the field I want, the formulas are not
updated unless I go in each one and request an "update field".

If it was not in a "form" format, I could simply do a CTRL+A to cover
everything and do a F9 to update all fields that have formulas. I'm not being
able to do the same in the protected form format. Any clue to automate it ? I
don't mind placing a "macro" button in the file to do the calculation, but I
don't know what steps to take

Thanks in advance
Renato

[Jay Freedman]

In the Properties dialog of each form field that contributes a value to the
formula, put a check mark in the box for "Calculate on exit". Whenever you
tab or click out of a field, that will cause the formulas that reference
that field to update.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Renato - Brazil wrote:
I created a form in which numerical inputs, placed in collumns, will
be calculated with a formula placed in the last collumn. When I
protect the form, to limit users to only access the field I want, the
formulas are not updated unless I go in each one and request an
"update field".

If it was not in a "form" format, I could simply do a CTRL+A to cover
everything and do a F9 to update all fields that have formulas. I'm
not being able to do the same in the protected form format. Any clue
to automate it ? I don't mind placing a "macro" button in the file to
do the calculation, but I don't know what steps to take

Thanks in advance
Renato

[Renato - Brazil]

Thanks a lot Jay!!!! It worked!!! Simple, but I was looking in different
places to have that.

"Jay Freedman" wrote:

In the Properties dialog of each form field that contributes a value to the
formula, put a check mark in the box for "Calculate on exit". Whenever you
tab or click out of a field, that will cause the formulas that reference
that field to update.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Renato - Brazil wrote:
I created a form in which numerical inputs, placed in collumns, will
be calculated with a formula placed in the last collumn. When I
protect the form, to limit users to only access the field I want, the
formulas are not updated unless I go in each one and request an
"update field".

If it was not in a "form" format, I could simply do a CTRL+A to cover
everything and do a F9 to update all fields that have formulas. I'm
not being able to do the same in the protected form format. Any clue
to automate it ? I don't mind placing a "macro" button in the file to
do the calculation, but I don't know what steps to take

Thanks in advance
Renato