Security III: Sign your own macros for stronger security

Security images

Learn why signing your own macros will reduce the number of security warnings you see while still maintaining a high security level, and find out how to sign a macro by using self-certification.

Start course button

About this course

This course includes:

  • One practice session for hands-on experience. Practices require Excel 2007.

  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Digitally sign your own macros to prevent frequent security warnings.

  • Run macros that you've written and signed without seeing security warnings.

  • Create and sign your own digital certificates and add them to the list of trusted publishers.

Before you begin

You should have a comprehensive understanding of macros, digital certificates, and trusted publishers, or have taken these courses:

You will need administrator rights to your computer to be able to install the SelfCert.exe file. If you're not sure whether you have administrator rights to your computer, talk to the person who is in charge of the computers in your office.

The processes in this course apply to Microsoft Office Access 2007, Microsoft Office Excel 2007, Microsoft Office PowerPoint 2007, and Microsoft Office Word 2007.

Topics in this course

  1. Certify yourself

  2. Certificates, signatures, and trusted publishers

  3. The keys behind the scenes

  4. Get a self-signed certificate

  5. Trust yourself

  6. Sign a macro

  7. Practice

  8. Quick reference card

Applies To: Excel 2007, Word 2007, PowerPoint 2007, Access 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language