digital signatures

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!!!!!