Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Allowing calculations in a table in a protected form?
I am trying to find a way to allow Word users to enter data into a table and
have simple calculations automatically update. The document is a protected form that allows users to input measurements into columns A and B, and ideally Column C should automatically calculate the sum of A and B. However, Word requires you to tab to the field and press F9 to get the result; since my form is protected they can't tab to that field. I tried setting it up in Excel and embedding the table, but Excel won't let me format cells as form fields that users can enter data into. Any help would be greatly appreciated. Thanks! |
#2
|
|||
|
|||
If C is a calculation form field and both A and B have "Calculate on exit"
set, C should update automatically. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Melissa Weiler" Melissa wrote in message ... I am trying to find a way to allow Word users to enter data into a table and have simple calculations automatically update. The document is a protected form that allows users to input measurements into columns A and B, and ideally Column C should automatically calculate the sum of A and B. However, Word requires you to tab to the field and press F9 to get the result; since my form is protected they can't tab to that field. I tried setting it up in Excel and embedding the table, but Excel won't let me format cells as form fields that users can enter data into. Any help would be greatly appreciated. Thanks! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dragging table column resets | Tables | |||
Calculations in a table | Tables | |||
Row height problem with table in table | Tables | |||
table caption numbering | Tables | |||
Getting the format of a table | Tables |