I have completed a form and have input fields for amounts which I would like
to total. The formula field that does this requires an update to run the
formula. I inserted a macro to run on exit of any of the amount input fields.

Sub update

ActiveDocument.Fields.Update

End sub

This works fine at my machine. However when I distribute it I get an error
due to the security settings on client machines on the network. I dont want
to remove the security or reduce the level - I'm not sure users can be relied
upon to only allow macros from trusted sources (whatever that is) and I also
would prefer a seamless update that does not rely on users input.

Am I stuffed or is there a work around? Signing project e.g. ?

You have no control over whether a user will enable the macros in your
document - nor should you have as this would open the door to malicious
code. The way to achieve what you want is to supply the macros in a global
template that all the users have access to.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Redapples wrote:
I have completed a form and have input fields for amounts which I
would like to total. The formula field that does this requires an
update to run the formula. I inserted a macro to run on exit of any
of the amount input fields.

 Sub update

     ActiveDocument.Fields.Update

 End sub

This works fine at my machine. However when I distribute it I get an
error due to the security settings on client machines on the network.
I dont want to remove the security or reduce the level - I'm not sure
users can be relied upon to only allow macros from trusted sources
(whatever that is) and I also would prefer a seamless update that
does not rely on users input.

Am I stuffed or is there a work around? Signing project e.g. ?

Calculated form fields should update automatically provided each form field
that contributes to the calculation has the "Calculate on exit" property
enabled.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Redapples" wrote in message
...
I have completed a form and have input fields for amounts which I would
like
to total. The formula field that does this requires an update to run the
formula. I inserted a macro to run on exit of any of the amount input
fields.

 Sub update

      ActiveDocument.Fields.Update

 End sub

This works fine at my machine. However when I distribute it I get an error
due to the security settings on client machines on the network. I dont
want
to remove the security or reduce the level - I'm not sure users can be
relied
upon to only allow macros from trusted sources (whatever that is) and I
also
would prefer a seamless update that does not rely on users input.

Am I stuffed or is there a work around? Signing project e.g. ?