Using Signed Macros with MS Office

Signing excel apps via a digital certificate can help guarantee that no one has tampered with the code and that what you are executing is what was originally written by the original signer. Further, it helps lock down your security policy. By only running signed code and only importing certificates from people you trust, you can prevent a situation where an an excel document can hijack your whole computer (because it can)

If you rely on VBA solutions within your organization, make sure you sign and then import certificates for all projects.

Sign with Certificate

When creating a VBA project that uses Macros, you can easily sign the project with a self signed certificate using the following steps:

  1. If you don’t already have one, you’ll need to create a self-signed certificate on your computer. If you do have one, you can skip to step 3. If not, go to the Start Menu > All Programs > Microsoft Office > Microsoft Office Tools > and open Digital Certificate for VBA Projects
    • 1
  2. Enter a name for your certificate and Click OK
    • 2
  3. Open up your VBA project in Excel, Word, Outlook (etc) and hit Alt + F11 to open up the VBA Project and go to Tools > Digital Signature
    • 3
  4. On the Digital Signature Menu, Click “Choose”
    • 4
  5. You should see the Certificate we just created. Select that and hit OK
    • 5

Import Certificate From Someone Else

When the file is opened on another machine, it won’t recognize the original certificate which only exists on the original author’s machine. Using the following steps we can import the certificate on the client’s machine.

Disclaimer: You should only perform these steps when you are absolutely certain that the file has originated from someone you trust to execute any commands on your machine without your knowledge.

  1. Open the Excel File with Macros and click “Options”
    • 1
  2. Click “Show Signature Details”
    • 2
  3. Click “View Certificate”
    • 3
  4. Click “Install Certificate”
    • 4
  5. Install Wizard Will Open
    • 5
  6. Select “Place all certificates in the following store” and Click “Browse”
    • 6
  7. Select “Trusted Root Certification Authorities”
    • 7
  8. Click OK / Next several times
    • 8
  9. Accept the Security Warning to Install the Certificate
    • 9
  10. On the original Dialog, Select “Trust all documents from this publisher” and Click OK
    • 10

Manage Certificates

If you want to go in and make changes to your certificates directly, you can view and edit all of the certs on your current system with the following steps.

  1. Hit Win + R to open up the Run Dialog
  2. Type “certmgr.msc” and Click OK
    • 1
  3. You should see the certificate we added in the Personal/Certificates folder
    • 2

Alternatively: You can also load your Computer’s Management Console by going to Start > Run mmc and then going to File > Add Snap In and then selecting Certificates.

And that’s it! Adding certificates to your projects is a great way to keep security in mind while providing some sort of automation within Office and other products.

33 comments:

  1. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. machine learning projects for final year In case you will succeed, you have to begin building machine learning projects in the near future.

    Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.


    Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.

    ReplyDelete
  2. Without fail, your writing style is top professional; even your website also looks amazing thank you for posting. microsoft office 2016 product key

    ReplyDelete
  3. I definitely enjoying every little bit of it. It is a great website and nice share. I want to thank you. Good job! You guys do a great blog, and have some great contents. Keep up the good work. free downloading ms office 2007

    ReplyDelete
  4. More often than not I don't offer remarks on sites, yet I'd prefer to state that this article truly constrained me to do as such. Extremely decent post. windows 10 professional product key UK

    ReplyDelete
  5. Hi! This is my first comment here so I just wanted to give a quick shout out and say I genuinely enjoy reading your blog posts. Can you recommend any other Fashion Write For Us blogs that go over the same topics? Thanks a ton!

    ReplyDelete
  6. The great service in this blog and the nice technology is visible in this blog. I am really very happy for the nice approach is visible in this blog and thank you very much for using the nice technology in this blog
    electronic signature software

    ReplyDelete
  7. Thanks for sharing your views about the concept which you know much better. Its easy to read and understand by the way you wrote the blog contents.

    python training in chennai

    ReplyDelete
  8. I feel really happy to have seen your web page and look forward to so many more entertaining times reading here. Thanks once more for all the details.

    best data science courses in chennai

    ReplyDelete
  9. Today's mobile, dispersed workforce faces communication and productivity challenges that have nothing to do with specific spreadsheet applications. The real problem is a lack of structure to serve the millions of communities that already have a spreadsheet they like: Excel. spreadsheet consulting

    ReplyDelete
  10. Thanks for sharing this quality information with us. I really enjoyed reading. Will surely going to share this URL with my friends. yourvirtualofficelondon.co.uk/limited-company-formation/

    ReplyDelete
  11. Excellent Blog. I can configure my new idea from this post. Detailed information is given. Thank you all for this valuable information Digital Signature

    ReplyDelete
  12. This is a fabulous article, please try to give more useful information.
    java basic tutorial
    python programming questions and answers pdf

    ReplyDelete
  13. Indeed, conversing with a realtor and finding what properties have been difficult to lease might be the way to getting a decreased regularly scheduled installment and greater adaptability in your rent choices. del mar office

    ReplyDelete
  14. this is really a good informative website i have ever every seen. i have got a lot of good knowledge from
    this site and i am waiting for the next blog.
    keep it up and give us good information
    for more information Office 365 Email Signature

    ReplyDelete
  15. Hi,
    I having many kinds of knowledge from your blog.. keep sharing !if you want list of audit firms bangalore big audit firms bangalore click on it

    ReplyDelete
  16. very nice article about signing macros and the way you explain smart watch is also awesome

    ReplyDelete

  17. i am very happy to read this blog. that is nice
    for more information
    best Office 365 Email Signature

    ReplyDelete
  18. An Office 365 migration everything over in batches. It transitions all of your resource mailboxes and existing users from One Office 365 tenant to another... During the migration, Office 365 users will still have the ability to send and receive emails from users that haven't migrated over yet.

    ReplyDelete
  19. i never know the use of adobe shadow until i saw this post. thank you for this! this is very helpful. پروژه ستین

    ReplyDelete
  20. I am glad to discover this page. I have to thank you for the time I spent on this especially great reading.
    I really liked each part and also bookmarked you for new information on your site.
    Reactjs Training in Chennai |
    Best Reactjs Training Institute in Chennai |
    Reactjs course in Chennai |

    ReplyDelete