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

  • Thread starter Thread starter BruceJ
  • Start date Start date
B

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
 
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.
 
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
 
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.
 
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
 
Works great! Thanks Doug!

Doug Glancy said:
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
Click to expand...
 
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
 
Back
Top