Wednesday, June 18, 2008

Deploying outlook 2007 VBA code using group policy with digital signature

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 comments:

Wen's Technical Diary said...

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!