Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I write a macro that updates a calculated field in a form?
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. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I write a macro that updates a calculated field in a form?
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. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "djjones" wrote in message ... 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form Field Updates when Accepting changes | Microsoft Word Help | |||
How do I show results of a calculated field on a protected form? | New Users | |||
Can I write a macro to attach a form and address an email at once? | Microsoft Word Help | |||
Calculated Form Field Option that sum other form fields | Microsoft Word Help | |||
I need to create a field in a form that automatically updates ano. | Microsoft Word Help |