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

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!