Digital signing of VBA projects

[Gary Hillerson]

Has anyone had success with digitally signing a VBA project that is
distributed in a Word template file?

I tried doing this with Verisign a few years back and ran into
problems, and ended up giving up.

I want the behavior that allows a user to trust the project upon
originally creating a document based on the template, so that s/he
doesn't get asked if it's okay to enable macros whenever opening the
document.

Thanks in advance,
gary hillerson

 

[Jonathan West]

Hi Gary,

I do this all the time, with a certificate from Thawte. My experience is
that the user gets asked about trusting macros from this source the first
time the template is opened. If the user check the "Always trust macros"
checkbox, then the dialog doesn't appear again, for any template signed by
the same certificate.

The dialog doesn't appear at all if the user's security setting (Tools,
macro, Security, Trusted Sources) is set to "Trust all installed add-ins and
templates" and the template is placed in the user templates folder or a
subfolder of it, the Workgroup folder or a subfolder of it, or the Startup
folder.

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[Gary Hillerson]

Thanks, Jonathan.

I tried it with Verisign about 3 years ago, ran into problems, and
their tech support was completely worthless.

I'll look into Thawte. Many thanks

gary