digital signatures

**jimmy@9830** · 12-11-2007, 12:52 PM

hi all

i have a bit of a problem...... so i have this spreadsheet i need to distribute... but i need the macros to be enabled at all times.

the only way i can do this is to sign he macro digitally.... now i have exported the certificate and need it to be installed on all the relevant pc's and then i have to manually sign every macro on every computer.....

is there a way i can automate this???? like an install file containig the spreadsheet and digital signature????

please help!!!!!

**Leith Ross** · 12-11-2007, 02:27 PM

Hello jimmy@9830,

Have a look at this link. It will walk you through the process of both importing and exporting a certificate for a VBA project.

Create a Digital Signature

Sincerly,
Leith Ross

**royUK** · 12-11-2007, 03:27 PM

I think you will find that you need a commercial certificate, not the self certs. Self certs can be used on your own PC or maybe a company network.

**jimmy@9830** · 12-11-2007, 05:36 PM

hi roryuk.

How do i create a commercial signature.....?????

I have created a selfcert and exported it...... only prob is that the people i am distributing this to will not know how to install it seccessfully....