View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bruno Guillemette Bruno Guillemette is offline
external usenet poster
 
Posts: 1
Default VBA Code Signing

Hi,

I'm doing some macros for Excel - to be used mostly inside our company.
Since we use Office XP, the certificate used to sign these macros are
generated from our own Certificate Server.

Some of these macros change the VBA code associated with a worksheet. Of
course, when this happens, the VB project needs to be resigned.

The problem I have is that about 3 peoples will be using the code altering
macros - so I would need 3 different keys.

Would it be possible for the 3 users to use a single key for code signing,
so that whenever the code is changed by my macro the key would be found on
their machine and re-signing would not be necessary?

Thanks in advance for your help...

Bruno G.