How do I write a macro that updates a calculated field in a form?

D

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.
 
S

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.
 

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

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Clearing Fields in a Word Form 5
How do I clear a form? 0
Command button wz 2 function 1
Password protecting multiple pages, and then some. 7
Building Blocks and Macros 5
Update Fields Wreeks Havoc! 7
form buttons on sheet collapse on unhide - sometimes 5

Top