Calculations In A Table With Form Fields

J

Jeff

I have three columns and 35 rows in a table. I would like to do a calculation on column A and column B and put the result in column C for each row. I would like to have form fields in columns A and B so users can tab through the form quickly and not be able to mess with the formula. When I do not use form fields everything works fine. The problem is when I protect my document for the form fields I'm unable to select my table (the option on the menu is grayed out) and then hit the F9 key to update my calculations since the document is protected. How can I resolve this????
 
C

Charles Kenyon

On each formfield that will be used in your calculation, check the field
property for "calculate on exit." Your totals will be updated when a user
tabs or clicks out of one of these fields.
--

Charles Kenyon

See the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

Jeff said:
I have three columns and 35 rows in a table. I would like to do a
calculation on column A and column B and put the result in column C for each
row. I would like to have form fields in columns A and B so users can tab
through the form quickly and not be able to mess with the formula. When I
do not use form fields everything works fine. The problem is when I protect
my document for the form fields I'm unable to select my table (the option on
the menu is grayed out) and then hit the F9 key to update my calculations
since the document is protected. How can I resolve this????
 

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

Top