I do it, but each machine has to install your certificate as a trusted certificate. In some companies that might be considered a security hole. IMO, if they trust your code, they may as well trust your certificate.
Also, each new release of Excel twists this process a new way. And of course it may vary on different releases of Windows - I do not know. Details are all over the web.
Basically there has to be a "first time" during which the user tries to open the signed Excel file, on the deployed-to machine, and Excel objects to the macros. Then, the user does "Details", and clicks things, until the certicate is installed. Then the user closes the Excel file, then opens it, and all is good.
This is fine for me because I am deploying to our own servers, but for deploying to users who do not know you, documenting and communicating the procedure(s) is a real bear. GL.
DStron wrote:
Distribute Digitally Signed (selfcert used to sign) Macros to othe
30-Oct-08
I am wanting to distribute a digitally selfcert signed macro or project to
others on exchange server where users are running XP Pro machines and Outlook
2003. I have created a selfcert file on my machine and have been asked to
have the security settings set to high on all machines. I do not have access
to a com add-in.
Is there a way to transfer my cert to another users machine
David
Previous Posts In This Thread:
Distribute Digitally Signed (selfcert used to sign) Macros to othe
I am wanting to distribute a digitally selfcert signed macro or project to
others on exchange server where users are running XP Pro machines and Outlook
2003. I have created a selfcert file on my machine and have been asked to
have the security settings set to high on all machines. I do not have access
to a com add-in.
Is there a way to transfer my cert to another users machine
David
No.
No. Either each user must generate a certificate and sign the code or your
organization must issue a certificate if you run a certificate server or you
have to purchase a certificate
Also, deploying VBA projects is not at all recommended. The recommended way
to deploy code is a COM addin
--
Ken Slova
[MVP - Outlook
http://www.slovaktech.co
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.ht
Submitted via EggHeadCafe - Software Developer Portal of Choice
AJAX Web Service Driven Customers Table With Customer Details
http://www.eggheadcafe.com/tutorial...en-customers-table-with-customer-details.aspx