Self-certification to avoid macro security dialogs
Your organization requires that all macros and add-ins have a security certificate before they're allowed to run in PowerPoint. This prevents you from running even your own macros or add-ins.
For use on your own PC, you can "self-certify" your code.
- Locate and run selfcert.exe. If installed, it will be in Program Files\Microsoft Office\Office xx (substitute 12 for xx if using Office 2007, 11 for Office 2003)
- Create a cert with your name.
- Open the presentation that contains your code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Tools | Digital Certificates
- Add the new certificate to your presentation.
- Quit the VB Editor
- Save and reopen your presentation.
- When you open the presentation again, you should be given the option to "Always Trust This Publisher". Accept it.
- From now on, your presentation (and any others that you self-certify) should open without security prompts.
Self-certificates work only on your own PC. If you need to certify and distribute presentations or add-ins to other users, you'll need a regular commercial code certificate. The SelfCert.exe dialog (shown above) contains more information about this and a link to a list of commercial certificate providers.