How/where can I get a digital signature certificate for signing macros so they are trusted?

[Dan E]

I'm designing spreadsheets that use macros for a health care facility for
free. I'd like to be able to sign the macros with a trusted certificate so
they don't have to go through the rigmarole of changing macro security
settings to medium or low. Any advice on best/cheapest way to get such a
certificate would be much appreciated, and acknowledged.

TIA,

Dan E

 

[Guest]

See this site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsecure/html/rootcertprog.asp

 

[Paul B]

Dan, this may be and option, it would be the "cheapest" way I think, but you
would have to put it on each computer there.

This applies to Excel 2000 and newer versions

You can create a self-signed digital certificate to use on your files with
SelfCert.exe, the file with the certificate is allowed to be opened with no
warning.

To use SelfCert.exe,
Open Windows Explorer and find your Office folder. Find SelfCert.exe and
run it. Or use find, start find, files or folders, type in SelfCert.exe and
search your hard drive, double click on it from there to run it

This certificate is good only on your computer, but it can be assigned to
more than
one file.

Once you have created the certificate open the file you want to sign, go to
the
VB Editor, Alt.+ F11, and select your VBA project.

Tools, Digital Signature, Choose. Select the Certificate you just created.

OK till you are out and save your file.

The next time you open this file you will not get the warning.


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Dan E]

Many thanks for your input, JLG. Doesn't look like there's an individual
code signing certificate available cheaply. I guess that's the way it
should be, since they have to verify identity etc. I guess I'll just have
to email instructions to the users to set macro security to Medium.

Dan E

 

[Dan E]

Many thanks Paul - actually I've already done that, but as you say, it's
only good on my computer. XP doesn't seem to allow the private key to be
exported, which is what Knowledgebase/Technet says you need to do, so I'll
just email the users instructions for setting macro security to medium -
certs are just tto expensive.

Thanjs again.

Dan E