{"id":896,"date":"2017-02-20T11:39:32","date_gmt":"2017-02-20T11:39:32","guid":{"rendered":"https:\/\/www.thesslstore.com\/knowledgebase\/?post_type=ht_kb&p=896"},"modified":"2018-03-08T04:47:44","modified_gmt":"2018-03-08T04:47:44","slug":"sign-code-microsoft-visual-basic-applications","status":"publish","type":"ht_kb","link":"https:\/\/www.thesslstore.com\/knowledgebase\/code-signing-sign-code\/sign-code-microsoft-visual-basic-applications\/","title":{"rendered":"Sign Code with Microsoft Visual Basic for Applications (VBA)"},"content":{"rendered":"

A Code Signing Certificate can be used to digitally sign code or content developed by Microsoft Office applications such as Word, Excel, PowerPoint, and Visio. After you received the trusted certificate and saved the PFX (.p12) file, follow the instructions below to guide you through digitally signing a macro project:<\/p>\n

1. Open your macro project file<\/h3>\n

Open the file that contains your macro project<\/p>\n

2. Click Visual Basic<\/h3>\n

Under the Developer <\/strong>tab, in the Code <\/strong>section, click Visual Basic<\/strong><\/p>\n

Note:<\/em><\/strong> To add the Developer<\/strong> tab, click Microsoft Office Button<\/strong>, and then select Excel Options. <\/strong>Continue by clicking Popular <\/strong>and then the Show Developer<\/strong> tab in the Ribbon <\/strong>check box. <\/em><\/p>\n

3. Select your project<\/h3>\n

In your Visual Basic Project Explorer, select your project to sign<\/p>\n

4. Select the Tools menu<\/h3>\n

Select Tools<\/strong> menu and click Digital Signature<\/strong><\/p>\n

5. Select the certificate<\/h3>\n

Click Choose<\/strong> and select the certificate and then click OK <\/strong>twice<\/p>\n

Congratulations! Your macro project has been successfully signed.<\/p>\n

After installing the certificate, we highly recommend timestamping your code to ensure users can still verify your signature even after the certificate has expired.\u00a0Click here to learn more about timestamping<\/a>.<\/p>\n

Note<\/em><\/strong>: The above instructions apply to Excel, Word, Outlook, PowerPoint, Publisher, Visio, Visio Standard, Project, and Project Standard. <\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

A Code Signing Certificate can be used to digitally sign code or content developed by Microsoft Office applications such as Word, Excel, PowerPoint, and Visio. After you received the trusted certificate and saved the PFX (.p12) file, follow the instructions below to guide you through digitally signing a macro project:…<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[29],"ht-kb-tag":[],"class_list":["post-896","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-code-signing-sign-code"],"yoast_head":"\nHow to Sign Code with Microsoft Visual Basic for Applications - The SSL Store\u2122<\/title>\n<meta name=\"description\" content=\"A complete step-by-step guide on how to sign code in Microsoft VBA. Follow these steps to digitally sign your Microsoft Office Macros and Visual Basic applications.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.thesslstore.com\/knowledgebase\/code-signing-sign-code\/sign-code-microsoft-visual-basic-applications\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Sign Code with Microsoft Visual Basic for Applications - The SSL Store\u2122\" \/>\n<meta property=\"og:description\" content=\"A complete step-by-step guide on how to sign code in Microsoft VBA. Follow these steps to digitally sign your Microsoft Office Macros and Visual Basic applications.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.thesslstore.com\/knowledgebase\/code-signing-sign-code\/sign-code-microsoft-visual-basic-applications\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/thesslstoredotcom\" \/>\n<meta property=\"article:modified_time\" content=\"2018-03-08T04:47:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.thesslstore.com\/knowledgebase\/wp-content\/uploads\/2017\/03\/authenticode-step5.png\" \/>\n\t<meta property=\"og:image:width\" content=\"520\" \/>\n\t<meta property=\"og:image:height\" content=\"406\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"How to Sign Code with Microsoft Visual Basic for Applications - The SSL Store\u2122\" \/>\n<meta name=\"twitter:description\" content=\"A complete step-by-step guide on how to sign code in Microsoft VBA. Follow these steps to digitally sign your Microsoft Office Macros and Visual Basic applications.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.thesslstore.com\/knowledgebase\/wp-content\/uploads\/2017\/03\/authenticode-step5.png\" \/>\n<meta name=\"twitter:site\" content=\"@thesslstore\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Sign Code with Microsoft Visual Basic for Applications - The SSL Store\u2122","description":"A complete step-by-step guide on how to sign code in Microsoft VBA. Follow these steps to digitally sign your Microsoft Office Macros and Visual Basic applications.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.thesslstore.com\/knowledgebase\/code-signing-sign-code\/sign-code-microsoft-visual-basic-applications\/","og_locale":"en_US","og_type":"article","og_title":"How to Sign Code with Microsoft Visual Basic for Applications - The SSL Store\u2122","og_description":"A complete step-by-step guide on how to sign code in Microsoft VBA. Follow these steps to digitally sign your Microsoft Office Macros and Visual Basic applications.","og_url":"https:\/\/www.thesslstore.com\/knowledgebase\/code-signing-sign-code\/sign-code-microsoft-visual-basic-applications\/","og_site_name":"Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/thesslstoredotcom","article_modified_time":"2018-03-08T04:47:44+00:00","og_image":[{"width":520,"height":406,"url":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-content\/uploads\/2017\/03\/authenticode-step5.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_title":"How to Sign Code with Microsoft Visual Basic for Applications - The SSL Store\u2122","twitter_description":"A complete step-by-step guide on how to sign code in Microsoft VBA. Follow these steps to digitally sign your Microsoft Office Macros and Visual Basic applications.","twitter_image":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-content\/uploads\/2017\/03\/authenticode-step5.png","twitter_site":"@thesslstore","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.thesslstore.com\/knowledgebase\/code-signing-sign-code\/sign-code-microsoft-visual-basic-applications\/","url":"https:\/\/www.thesslstore.com\/knowledgebase\/code-signing-sign-code\/sign-code-microsoft-visual-basic-applications\/","name":"How to Sign Code with Microsoft Visual Basic for Applications - The SSL Store\u2122","isPartOf":{"@id":"https:\/\/www.thesslstore.com\/knowledgebase\/#website"},"datePublished":"2017-02-20T11:39:32+00:00","dateModified":"2018-03-08T04:47:44+00:00","description":"A complete step-by-step guide on how to sign code in Microsoft VBA. Follow these steps to digitally sign your Microsoft Office Macros and Visual Basic applications.","breadcrumb":{"@id":"https:\/\/www.thesslstore.com\/knowledgebase\/code-signing-sign-code\/sign-code-microsoft-visual-basic-applications\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.thesslstore.com\/knowledgebase\/code-signing-sign-code\/sign-code-microsoft-visual-basic-applications\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.thesslstore.com\/knowledgebase\/code-signing-sign-code\/sign-code-microsoft-visual-basic-applications\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.thesslstore.com\/knowledgebase\/"},{"@type":"ListItem","position":2,"name":"Sign Code with Microsoft Visual Basic for Applications (VBA)"}]},{"@type":"WebSite","@id":"https:\/\/www.thesslstore.com\/knowledgebase\/#website","url":"https:\/\/www.thesslstore.com\/knowledgebase\/","name":"Knowledge Base","description":"TheSSLstore","publisher":{"@id":"https:\/\/www.thesslstore.com\/knowledgebase\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.thesslstore.com\/knowledgebase\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.thesslstore.com\/knowledgebase\/#organization","name":"The SSL Store\u2122","url":"https:\/\/www.thesslstore.com\/knowledgebase\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.thesslstore.com\/knowledgebase\/#\/schema\/logo\/image\/","url":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-content\/uploads\/2017\/04\/thesslstore.jpg","contentUrl":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-content\/uploads\/2017\/04\/thesslstore.jpg","width":300,"height":300,"caption":"The SSL Store\u2122"},"image":{"@id":"https:\/\/www.thesslstore.com\/knowledgebase\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/thesslstoredotcom","https:\/\/x.com\/thesslstore","https:\/\/www.linkedin.com\/company\/the-ssl-store","https:\/\/www.youtube.com\/user\/thesslstore"]}]}},"_links":{"self":[{"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/896","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=896"}],"version-history":[{"count":0,"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/896\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=896"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb-category?post=896"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb-tag?post=896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}