Signing macro

[John]

Hi

I'm working on a project which will need to be digitally signed. Before I
spend any cash getting a certificate from Verisign etc does anyone know the
steps to take to create and install a certificate from my local Certificate
Authority then sign the VBA project with it?

Thanks

Jon

 

[Jay Freedman]

Hi

I'm working on a project which will need to be digitally signed. Before I
spend any cash getting a certificate from Verisign etc does anyone know the
steps to take to create and install a certificate from my local Certificate
Authority then sign the VBA project with it?

Thanks

Jon

Hi Jon,

I believe the procedure for getting a certificate from the CA depends
somewhat on how the CA is set up, but here's a description of one way
when you're dealing with a Windows 2000 Server:
http://www.microsoft.com/windows2000/en/server/help/sag_CMprocsReqCert.htm
There are also CAs with Web interfaces through IIS. Finally, I have
used a Verisign certificate that was supplied as two files, an
executable and a private key.

To sign a VBA project, in the VBA editor go to Tools > Digital
Signature. If you have more than one certificate installed, use the
Choose button to select the right one. Then click OK. Not too bad, eh?

 

[John]

Thanks

What type do i need please?

 

[Jay Freedman]

Thanks

What type do i need please?

What type of what?

Certificate? You need a code-signing certificate. See the "Office and VBA
Signing" item at
http://www.verisign.com/products-se...e-signing/digital-ids-code-signing/index.html
for a specific example, and
http://office.microsoft.com/en-us/assistance/HA011381041033.aspx for a more
general description.

Certificate authority? I don't know much about that. Besides the third-party
Web-based CAs such as Verisign and Thawte, you can set up a private in-house
CA, but what kind depends on what network servers you use and what OS (kind
and version) runs on the CA server.

I'd suggest you do a bit more reading. Start by running this Google search:

"certificate authority" "code signing" site:microsoft.com

and reading the first half-dozen articles it returns.