Allowing calculations in a table in a protected form?

M

Melissa Weiler

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

Suzanne S. Barnhill

If C is a calculation form field and both A and B have "Calculate on exit"
set, C should update automatically.
 

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