Digitally Sign an Office Macro

[Digiman57]

Hi,
I was wondering how to go about signing a Macro for corporate distribution.
The Macro may even be used in an employees home computuer...off of our domain.
I know we have a server setup on our domain for Web certificates and
probably has the ability to put an app signing add-in on the server, but I am
guessing that we have to go to an outside company to get a certificate to
digitally sign a macro, or even a stand alone app?
For a few people I have set up personal sigatures from Office 2003 tools, on
each person's computer.
Thanks for any info.
Jeff l

 

[ken.puls]

Hi there,

I created a digital certificate for my own in house projects using
selfcert.exe. You have to install it manually on every machine that
will use the program, but this only needs to be done once.

I did look in to buying a digital cert from Thawte or somewhere, but I
found the cost prohibitive. Especially given that the selfcert route
was free.

The only drawback is that you have to write/edit your code on the
machine where you generated the certificate. You can't modify/debug it
on the fly elsewhere, or the certificate is discarded. (In this case,
however, reopening it and resigning it on the original machine solves
that issue.)

I'm not sure how big your organization is (I have about 25 users) but
I'd just write up a guide to the installation and send it out with the
app.

A good article to get you started on this can be found here:
http://www.vbaexpress.com/forum/articles.php?action=viewarticle&artid=3

 

[cjakeman]

Might be worth trying the free certificates from www.cacert.org. The
one for code signing is a client certificate.

Hope this helps, Chris