{"id":1186,"date":"2010-06-14T11:19:06","date_gmt":"2010-06-14T09:19:06","guid":{"rendered":"https:\/\/www.peppercrew.nl\/?p=1186"},"modified":"2011-05-19T14:58:45","modified_gmt":"2011-05-19T13:58:45","slug":"enable-vbamarcos-in-excel-2010","status":"publish","type":"post","link":"https:\/\/ingmarverheij.com\/en\/enable-vbamarcos-in-excel-2010\/","title":{"rendered":"Enable VBA\/Macro&#8217;s in Excel 2010"},"content":{"rendered":"<p>If you want to use VBA (Visual Basic for Applications) or use Macro\u2019s in Excel 2010 you need to access the Developer view. In Excel 2007 this was a checkbox setting in the general options, but this has changed with Excel 2010.<\/p>\n<p>In order to enable the Developer tab in the ribbon you should follow the following steps:<br \/>\n1)\tOpen the File menu on the left side of the screen<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1187\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2010\/06\/Excel11.png\" alt=\"\" width=\"264\" height=\"284\" \/><br \/>\n<!--more--><br \/>\n2)\tClick options<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-1188\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2010\/06\/Excel21.png\" alt=\"\" height=\"457\" \/><\/p>\n<p>3)\tSelect  \u2018Customize Ribbon\u2019<br \/>\n4)\tEnable the checkbox \u2018Developer\u2019<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1189\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2010\/06\/Excel31.png\" alt=\"\" width=\"840\" height=\"685\" \/><\/p>\n<p>Now when you open Excel you have a new tab in the ribbon. Here you can find VBA and the Macro\u2019s.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1190\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2010\/06\/Excel41.png\" alt=\"\" width=\"804\" height=\"222\" \/><\/p>\n<p>Ingmar Verheij<\/p>","protected":false},"excerpt":{"rendered":"<p>If you want to use VBA (Visual Basic for Applications) or use Macro\u2019s in Excel 2010 you need to access the Developer view. In Excel 2007 this was a checkbox setting in the general options, but this has changed with Excel 2010. In order to enable the Developer tab in the ribbon you should follow [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[17],"tags":[205,206,59,62],"class_list":["post-1186","post","type-post","status-publish","format-standard","hentry","category-office","tag-developer","tag-excel-2010","tag-macro","tag-vba"],"_links":{"self":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/1186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/comments?post=1186"}],"version-history":[{"count":3,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/1186\/revisions"}],"predecessor-version":[{"id":2437,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/1186\/revisions\/2437"}],"wp:attachment":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/media?parent=1186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/categories?post=1186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/tags?post=1186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}