Protect a calculation field in a word table?

R

Rob Benz

We have a table in a word.doc that has fields in the total column such as
"=SUM(ABOVE)", "=SUM (B2,B4, B12)", etc.

Can we protect these calculation fields so that a user can't inadvertently
delete or over type them while adding numbers to the table? We want them to
be able to enter various number amounts, but not be able to accidentally
overtype or modify the calculated fields.
 
G

Graham Mayor

Insert form fields for the users to enter numbers and protect the document
for forms. Don't forget to check the calculate on exit check box of the form
fields to ensure that the calculation is updated.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

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

Average calculation 7
Field Calculations from Different Tables 1
If field calculation 13
Protect form filling in a table 1
Creating a date calculation with a text form field 2
How to hide the default 0.00 in a calculation field of a word form 1
Create error msg based on calculation result in formfield using VBA 1
Calculated fields in Word forms 2

Top