If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Text Form Field Calculation in a Protected Document
I have several text form fields with numbers in them. I have set up
calculations with the cell letters/numbers and have clicked the "calculate on exit" buttons, and the calculations work while I am in the document, editing it. However, after I protect the document and my form is ready to be filled in, any changes to the numbers don't auto-calulate. The number in the box that is supposed to be the calculation stays the same. Any ideas? |
#2
|
|||
|
|||
Text Form Field Calculation in a Protected Document
Have you checked "Calculate on exit" in each form field that contributes to
the calculation? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "elinhaw" wrote in message ... I have several text form fields with numbers in them. I have set up calculations with the cell letters/numbers and have clicked the "calculate on exit" buttons, and the calculations work while I am in the document, editing it. However, after I protect the document and my form is ready to be filled in, any changes to the numbers don't auto-calulate. The number in the box that is supposed to be the calculation stays the same. Any ideas? |
#3
|
|||
|
|||
Text Form Field Calculation in a Protected Document
Okay, now it is working! Thank you! I had the box checked in the form that
should have the calculated number, but not the other fields that were contributing to the calculation. Thank you very much. "Suzanne S. Barnhill" wrote: Have you checked "Calculate on exit" in each form field that contributes to the calculation? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "elinhaw" wrote in message ... I have several text form fields with numbers in them. I have set up calculations with the cell letters/numbers and have clicked the "calculate on exit" buttons, and the calculations work while I am in the document, editing it. However, after I protect the document and my form is ready to be filled in, any changes to the numbers don't auto-calulate. The number in the box that is supposed to be the calculation stays the same. Any ideas? . |
#4
|
|||
|
|||
Text Form Field Calculation in a Protected Document
You're welcome. It's a tiny but vital point that is far from intuitive or
obvious. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "elinhaw" wrote in message ... Okay, now it is working! Thank you! I had the box checked in the form that should have the calculated number, but not the other fields that were contributing to the calculation. Thank you very much. "Suzanne S. Barnhill" wrote: Have you checked "Calculate on exit" in each form field that contributes to the calculation? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "elinhaw" wrote in message ... I have several text form fields with numbers in them. I have set up calculations with the cell letters/numbers and have clicked the "calculate on exit" buttons, and the calculations work while I am in the document, editing it. However, after I protect the document and my form is ready to be filled in, any changes to the numbers don't auto-calulate. The number in the box that is supposed to be the calculation stays the same. Any ideas? . |
Thread Tools | |
Display Modes | |
|
|