Digital signing of VBA projects

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gary Hillerson - 21 Feb 2006 03:22 GMT

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

Reply to this Message

Jonathan West - 21 Feb 2006 12:28 GMT

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.

Signature

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

> Has anyone had success with digitally signing a VBA project that is
> distributed in a Word template file?
[quoted text clipped - 9 lines]
> Thanks in advance,
> gary hillerson

Reply to this Message

Gary Hillerson - 21 Feb 2006 23:16 GMT

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

>Hi Gary,
>
[quoted text clipped - 9 lines]
>subfolder of it, the Workgroup folder or a subfolder of it, or the Startup
>folder.

Reply to this Message