1, write the code;
2, generate code signing certificate using enterprise CA;
3, Sign the macro code with certificate;
4, copy VBAProject.otm and the certificate to netlogin folder;
5, create GPO, link a logon script to copy vbaproject.otm to user profile and create a certificate rule to publish the certificate
1 comment:
Unfortunately the above code won't work without manual activation. looks like the only way to do it properly it via outlook com add-in. Thus I have changed the project to a outlook com add-in and it works seamlessly now!
Post a Comment