How to update a formula in a table that is a protected form ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Thanks a lot Jay!!!! It worked!!! Simple, but I was looking in different
places to have that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Protected Form w/ Updateable Fields in Table 3
MS word update field problem 1
Excel Protection 2
FORMTEXT field erases contents when updated with F9 1
Creating a date calculation with a text form field 2
Printing Completed Forms and repeating ref fields 5
How to Update Source File IncludeText from a Target File if Source in a Text Control? 0
Protect form filling in a table 1

Back
Top