Signing Macros

D

Dan

I was just wondering how to sign a macro. I made the
macro and the help says that I can sign either sign the
macro or I can turn the security down. Thanks for your
help
 
D

Dan

This was just a file that I created from scratch and
there is no certificates. Is there anyway that I can
create one?
 
F

Frank Kabel

Hi
the VBA help outlines how to create a new certificate (search for
'certificate')
 
G

Gord Dibben

Dan

Using Excel 2000 and newer.

You can create a digital certificate and use that on your VBAProject so that
file with the certificate is allowed to be opened with no warning.

You can get to SelfCert either of these ways........

1. Start>Programs>Microsoft Office>Tools>"Digital Certificate for VBA
Projects"

2. Open Windows Explorer and drill down to your Office folder. Find
SelfCert.exe and run it.

This certificate is good only on your computer but can be used for more than
one file.

Once the certificate has been created and with your file open, go to the
VBEditor and select your VBAproject/file.

Tools>Digital Signature>Choose. Select the Certificate you just created.

OK your way out and save your file.

Next time you open this particular file you will not get the warning.

Gord Dibben Excel MVP
 
R

rpw

sorry, let me re-phrase question... what must happen on another computer to allow the macros? Can the self-cert be shared with the other stations

----- rpw wrote: ----

after creating a self-cert then share the file to another computer is the cert recognized or do they have to do something over there to allow the macros

----- Gord Dibben wrote: ----

Da

Using Excel 2000 and newer

You can create a digital certificate and use that on your VBAProject so tha
file with the certificate is allowed to be opened with no warning

You can get to SelfCert either of these ways.......

1. Start>Programs>Microsoft Office>Tools>"Digital Certificate for VB
Projects

2. Open Windows Explorer and drill down to your Office folder. Fin
SelfCert.exe and run it

This certificate is good only on your computer but can be used for more tha
one file

Once the certificate has been created and with your file open, go to th
VBEditor and select your VBAproject/file

Tools>Digital Signature>Choose. Select the Certificate you just created

OK your way out and save your file

Next time you open this particular file you will not get the warning

Gord Dibben Excel MV

On Thu, 27 May 2004 14:49:27 -0700, "Dan
 
R

rpw

Sorry, again. looked into the self-cert process and it explains it there clearly..... Doh!

----- rpw wrote: ----

sorry, let me re-phrase question... what must happen on another computer to allow the macros? Can the self-cert be shared with the other stations

----- rpw wrote: ----

after creating a self-cert then share the file to another computer is the cert recognized or do they have to do something over there to allow the macros

----- Gord Dibben wrote: ----

Da

Using Excel 2000 and newer

You can create a digital certificate and use that on your VBAProject so tha
file with the certificate is allowed to be opened with no warning

You can get to SelfCert either of these ways.......

1. Start>Programs>Microsoft Office>Tools>"Digital Certificate for VB
Projects

2. Open Windows Explorer and drill down to your Office folder. Fin
SelfCert.exe and run it

This certificate is good only on your computer but can be used for more tha
one file

Once the certificate has been created and with your file open, go to th
VBEditor and select your VBAproject/file

Tools>Digital Signature>Choose. Select the Certificate you just created

OK your way out and save your file

Next time you open this particular file you will not get the warning

Gord Dibben Excel MV

On Thu, 27 May 2004 14:49:27 -0700, "Dan
 
G

Gord Dibben

I have heard of it being done by exporting the certificate and having the
recipient install on their machine in the Trusted Root Certification
Authorities folder.

If you would like to experiment, I can send a small file with macros in it
signed by a selfcert certificate and a copy of the selfcert certificate for
you to install.

Any takers?

Gord
 
Top