Prev: Delegate constructor compiles in VB.NET, but not in Excel VBA
Next: date & time formulas HELP !!
From: dougp on 4 Jun 2010 13:23
I am having difficulties in getting my SelfCert to attached to a macro. I go
to Tools/Digital Signature and assign my certificate but this doesn't allow
the macro to run. I am also trying to use my certificate on other computers
in our office but I am having difficulty with that as well. The certificate
can be attached but cannot be saved to the macro on other computers.
From: NoSpam on 4 Jun 2010 16:28
You must install the certificate to a trusted location using the wizard.
Do do thin, find your certificate with Windows Explorer, whatever.cer, and
double click it. Respond to the wizard's simple dialogs and choose a
trusted root location from the list. You will need to do this on each
mchine on which your signed macros are to be used.

On Fri, 4 Jun 2010 10:23:29 -0700, dougp <dougp(a)discussions.microsoft.com>
wrote:

>I am having difficulties in getting my SelfCert to attached to a macro. I go
>to Tools/Digital Signature and assign my certificate but this doesn't allow
>the macro to run. I am also trying to use my certificate on other computers
>in our office but I am having difficulty with that as well. The certificate
>can be attached but cannot be saved to the macro on other computers.

From: Gord Dibben on 5 Jun 2010 11:01
SelfCert signatures are good only on the computer in which they are created.

You cannot export the selfcert key(s).

Using the certificate on your own computer should pose no problem but you
say your macros won't run.

If using 2007, have you saved the workbook as macro-enabled
workbook(*.xlsm)?

One thing you mifgt try is to open MMC from Start>Run MMC

Load the certificate snap-in and move your certificate from Personal to
Trusted.


Gord Dibben MS Excel MVP

On Fri, 4 Jun 2010 10:23:29 -0700, dougp <dougp(a)discussions.microsoft.com>
wrote:

>I am having difficulties in getting my SelfCert to attached to a macro. I go
>to Tools/Digital Signature and assign my certificate but this doesn't allow
>the macro to run. I am also trying to use my certificate on other computers
>in our office but I am having difficulty with that as well. The certificate
>can be attached but cannot be saved to the macro on other computers.

 | 
Pages: 1
Prev: Delegate constructor compiles in VB.NET, but not in Excel VBA
Next: date & time formulas HELP !!