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.
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.