{"id":2963,"date":"2016-03-19T07:54:05","date_gmt":"2016-03-19T07:54:05","guid":{"rendered":"http:\/\/www.ericwhite.com\/home2\/bm8qcmjy\/public_html\/blog\/?page_id=2963"},"modified":"2016-03-19T07:54:05","modified_gmt":"2016-03-19T07:54:05","slug":"using-open-xml-package-editor-to-customize-ribbon-deploy-as-vba-add-in","status":"publish","type":"page","link":"https:\/\/www.ericwhite.com\/blog\/using-open-xml-package-editor-to-customize-ribbon-deploy-as-vba-add-in\/","title":{"rendered":"Using Open XML Package Editor to Customize Ribbon, Deploy as VBA Add-In"},"content":{"rendered":"<p>In a previous screen-cast, I showed the basic steps to customize a ribbon and call a VBA function from the XML that defines the customization. &nbsp;In this video I go one step further &#8211; I show a more interesting ribbon customization, and I show how to deploy as a VBA Add-In.<\/p>\n<p>In the XML that defines the customized ribbon, there are identifiers that you use to identify existing ribbon artifacts. &nbsp;For instance, if you are modifying the Data Tab, there is an identifier, TabData, that you use to indicate which tab you are customizing. &nbsp;The video shows how to look up the appropriate identifiers in a downloadable spreadsheet. &nbsp;You can download the list of available identifiers at&nbsp;<a href=\"http:\/\/www.microsoft.com\/download\/en\/details.aspx?id=6627\" class=\"broken_link\">http:\/\/www.microsoft.com\/download\/en\/details.aspx?id=6627<\/a>.<\/p>\n<p>In addition, in the XML, you can use image identifiers to access a large number of stock icons that you can use in the ribbon. &nbsp;You can find the complete list of images in a macro enabled Word document at&nbsp;<a href=\"http:\/\/www.microsoft.com\/download\/en\/details.aspx?id=21103\" class=\"broken_link\">http:\/\/www.microsoft.com\/download\/en\/details.aspx?id=21103<\/a>.<\/p>\n<p>The first video in this series is&nbsp;<a href=\"https:\/\/www.ericwhite.com\/blog\/using-open-xml-package-editor-to-create-a-ribbon-button-that-runs-a-vba-function\/\">Using Open XML Package Editor to Create a Ribbon Button that runs a VBA Function<\/a>.<\/p>\n<p><iframe loading=\"lazy\" title=\"Customize-Ribbon-Create-VBA-Add-In.wmv\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/UUx4k0_gZOo?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In a previous screen-cast, I showed the basic steps to customize a ribbon and call a VBA function from the XML that defines the customization. &nbsp;In this video I go one step further &#8211; I show a more interesting ribbon customization, and I show how to deploy as a VBA Add-In. In the XML that [&hellip;]<\/p>\n","protected":false},"author":10567,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_s2mail":"","footnotes":""},"class_list":["post-2963","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2963","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/users\/10567"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/comments?post=2963"}],"version-history":[{"count":1,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2963\/revisions"}],"predecessor-version":[{"id":2964,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2963\/revisions\/2964"}],"wp:attachment":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/media?parent=2963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}