Can I "sign" my own macros? or some other fix for the message about security and macros?

[BruceJ]

I have several macros I have created and I would like to have high security,
or at least medium, but I don't like excel asking me each time I start about
the "Enable/Disable Macros." is there a way I can tell Excel that these
macros are OK?

Thanks
Bruce

 

[Alan]

The reason for the macro warning is that its fairly easy to write malicious
code that will damage another persons computer, ie Viruses. The warning
cannot be turned off for this reason, it runs first before anything else is
shown, if it could be turned off the sad Virus writing fraternity would have
a field day as they would be able to do it via VBA code and infect your
machine without any warning or consent.

 

[Kevin Stecyk]

Alan,

I believe you can sign your own macros. Look under help for "Create your
own digital certificate".

If you plan to have your macros run on other computers, you might want to
purchase a digital certificate from Verisign or one of other vendors.

I don't know much about Digital Certificates, so perhaps others can join in
and assist.

Best regards,
Kevin

 

[Tom Ogilvy]

http://support.microsoft.com/?KBID=206637
OFF2000: Overview of Digital Certificates (Q206637)

http://support.microsoft.com/?KBID=217221
OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
(Q217221)

use SelfCert

 

[Dave R.]

I tried this selfcert thing, but how do I tell Office that I am "Dave" (who
I created the certificate for) and it's ok to automatically open files that
have macros by "Dave". Trusted sources apparently doesn't let me add any
names.

 

[Doug Glancy]

Dave,

I just tried this for the first time after reading the above posts. In VBE
under tools, I clicked Digital Signatures and chose the signature. The
first time I opened thenworkbook I got a dialog box that offers the option
to "always trust files from this source" or something like that. I chose
that option and mow the workbook just opens with no macro dialogs.

hth,

Doug

 

[Dave R.]

Works great! Thanks Doug!

Dave,

I just tried this for the first time after reading the above posts. In VBE
under tools, I clicked Digital Signatures and chose the signature. The
first time I opened thenworkbook I got a dialog box that offers the option
to "always trust files from this source" or something like that. I chose
that option and mow the workbook just opens with no macro dialogs.

hth,

Doug

 

[BruceJ]

Tom, I can not find "Selfcert" I DO have a MAKECERT that was installed when
I followed the steps listed. Is this the same?

Bruce

 

[BruceJ]

Oppps.....
I did find it!
Sorry! It worked like a charm as advertised!

Bruce