How to update a formula in a table that is a protected form ?
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
|