Update field and macro security

[Guest]

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. ?

 

[Graham Mayor]

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

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

 

[Suzanne S. Barnhill]

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

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.