Update fields problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sueo - 29 Apr 2004 19:38 GMT

I have a word form that has some formulae in. The form
will need to be protected. I wanted to record a macro
that would do an update fields on my formulae fields, but
this is not possible if the form is prtected. Can anyone
suggest how I can get around the problem?

Many thanks for any help

Sue

Reply to this Message

Greg Maxey - 29 Apr 2004 22:27 GMT

Sueo,

If the variables are entered as inputs to fields in the from, then set the
fields to calculate on exit (double click the field and check the "Calculate
on exit" option).

If you need to run macro, you can run it with a macrobutton field in the
form.

Sub Test()
ActiveDocument.Fields.Update
End Sub

{ Macrobutton Test "Doubleclick to update fields"}

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in gmaxey@whamspammvps.org

> I have a word form that has some formulae in. The form
> will need to be protected. I wanted to record a macro
[quoted text clipped - 5 lines]
>
> Sue

Reply to this Message

Charles Kenyon - 29 Apr 2004 22:33 GMT

Change the fields that are used for input to your calculation so that the
"calculate on exit" property is checked. You do not need a macro for this.
You can leave your document protected (after you've changed that property).

For more about online forms, follow the links at
http://addbalance.com/word/wordwebresources.htm#Forms or
http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially Dian
Chapman's series of articles.

Hope this helps,

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: 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.

> I have a word form that has some formulae in. The form
> will need to be protected. I wanted to record a macro
[quoted text clipped - 5 lines]
>
> Sue

Reply to this Message