A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Text Form Field Calculation in a Protected Document



 
 
Thread Tools Display Modes
  #1  
Old December 10th, 2009, 08:06 PM posted to microsoft.public.word.tables
elinhaw
external usenet poster
 
Posts: 2
Default 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  
Old December 10th, 2009, 08:48 PM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default 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  
Old December 22nd, 2009, 04:57 PM posted to microsoft.public.word.tables
elinhaw
external usenet poster
 
Posts: 2
Default 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  
Old December 22nd, 2009, 06:09 PM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.