Related Posts Plugin for WordPress, Blogger...

How To Digitally Sign Macros and Skip Macro Settings


The other day, I have finished creating a macro in Microsoft Outlook to send mass of emails with different recipients, email address and account number. It just puzzled me that the next day my macro suddenly isn't working at all and it says that my macros are disabled and unsigned.

After doing my research, I have found a solution to digitally signed the macros and skip the macro settings. This will also be applicable on other Microsoft products which uses macro like Excel and Access.

Follow these steps:

1) Locate the Selfcert.exe file which is located at C:\Program Files\Microsoft Office\Office . Double-click the executable file then enter your name in the certificate name.

How To Digitally Sign Macros and Skip Macro Settings


2) Go to your macro coding by clicking Alt+F11 then select Digital Signature from the Tools menu. Click the Choose button then select your newly created digital signature.

How To Digitally Sign Macros and Skip Macro Settings

3) Save your macro then restart your Microsoft Outlook.

4) Open your macro by clicking Alt+F8. A Security Warning window will pop-up and ask you if you want to enable the macro using the publisher. I suggest that you select the option to trust macros from this publisher.

5) Trigger your macro and you're all set with the wonders of macro programming.

If you like this post, buy me a cup of coffee.

Share This Post Digg This Del.icio.us Furl Reddit Fav This With Technorati Yahoo MyWeb Stumble This

0 comments


Namecheap.com - Cheap domain name registration, renewal and transfers - Free SSL Certificates - Web Hosting