Re: how to digitally sign a macro?

From: .:mmac:. (lost_at_sea)
Date: 12/04/04 

Date: Fri, 3 Dec 2004 17:27:09 -0800

Ahh, that sounds like the ticket, Thanks, I'll try that on Monday.

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:dg02r0t2obt09rtipqpbkmm7in3dh7k8ba@4ax.com...
> For your own use?
>
> See Help on "creating digital certificates" and check the section on
> "SelfCert"
>
> The following is from my own experience..........
>
> You can create a digital certificate and use that on your VBAProject so
> only
> 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.
>
> NOTE: DC's are not available for Excel 97
>
> If you still have trouble with this, post back and we can walk through
> adding
> a selfcert to the trusted certificates store via Windows Microsoft
> Management
> Console.
>
> Gord Dibben Excel MVP
>
> On Fri, 3 Dec 2004 14:20:18 -0800, ".:mmac:." <lost@sea> wrote:
>
>>How do I digitally sign a macro so I don't get the warning when it opens?
>>I'm using Office 2003
>>
>

Relevant Pages

  • Access 2003 Runtime With Digital Certificates
    ... only way to add your certificate to the Trusted Publishers list is through ... this publisher and open them automatically'. ... Subsequent open attempts on DB opens without warning. ... Use Remove button on Trusted Publisher tab to remove ourself from Trusted ...
    (microsoft.public.access.security)
  • Re: Error using E-mail encryption
    ... encrypted emails but when I try to open an encrypted email I get the error ... The sender can encrypt the message but the recipient can't decrypt it because there's no private key anymore. ... When the certificate manager opens, ...
    (microsoft.public.outlook)
  • Re: Is it possible for me to have an alert pop-up when I open a do
    ... When you open the workbook you will be asked if you want to enable macros. ... Gord Dibben MS Excel MVP ... author using a certificate issued by a Certificate Autority." ... header of the activesheet when the workbook opens. ...
    (microsoft.public.excel.misc)
  • Re: ruby certification
    ... add my UW certificate experience to my resume because it opens a line of ... If I am applying for a Ruby programmer position, ... I went into the interview armed with knowledge about him ...
    (comp.lang.ruby)
  • Re: Macro dialog box when opening worksheet
    ... 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. ... Next time you open this particular file you will not get the warning. ...
    (microsoft.public.excel.misc)