Disabling Macro Warning in User Form for all Users

[mela]

Hello-

I know there are quite a few questions posted on this board about disabling
the macro security warnings. I know that it is possible to prevent the
warning from coming up every time but changing the security setting to
medium, authenticate, etc. etc. However, I want to be able to disable the
warning for all of my form users, who will find it a complete annoyance and
frustration to have to go and do it themselves (they are sales people with
little time or patience). Is it possible to get rid of a macro warning once
and for all without having to make each user do it on their own? It's a very
frustrating issue when trying to create user-friendly forms (contract
templates) in Word. Thank you.

 

[Jay Freedman]

Hello-

I know there are quite a few questions posted on this board about disabling
the macro security warnings. I know that it is possible to prevent the
warning from coming up every time but changing the security setting to
medium, authenticate, etc. etc. However, I want to be able to disable the
warning for all of my form users, who will find it a complete annoyance and
frustration to have to go and do it themselves (they are sales people with
little time or patience). Is it possible to get rid of a macro warning once
and for all without having to make each user do it on their own? It's a very
frustrating issue when trying to create user-friendly forms (contract
templates) in Word. Thank you.

There's only one way, and that's to sign the macro code with a digital
certificate issued by a root authority. The big names there are
VeriSign and Thawte, but they're expensive (hundreds of dollars per
year). Comodo (http://www.instantssl.com/code-signing/) is somewhat
less expensive. This site may also be helpful:
http://www.x2net.com/signcode/index.htm.

Once you have a certificate installed on your computer, open the VBA
editor, click Tools > Digital Signature, and apply the certificate to
the macro project (you don't need a separate tool as you would for
signing a .exe file).