View Single Post
  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Renato - Brazil Renato - Brazil is offline
external usenet poster
 
Posts: 1
Default How to update a formula in a table that is a protected form ?

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