{"id":12071,"date":"2011-10-11T18:06:52","date_gmt":"2011-10-11T18:06:52","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=64"},"modified":"2022-08-20T15:10:51","modified_gmt":"2022-08-20T15:10:51","slug":"add-developer-tab-in-excel-2010-and-2007","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/","title":{"rendered":"Excel Macro Tutorial : Add Developer Tab in Excel – 2007 and 2010"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ da_disable_devices=”off|off|off” global_colors_info=”{}” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.17.6″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n

Video : how to add the Developer Tab in Excel 2007<\/h2>\n

[\/et_pb_text][et_pb_video src=”https:\/\/www.youtube.com\/watch?v=mhKCYgHV20s” _builder_version=”4.17.6″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_video][et_pb_text _builder_version=”4.17.6″ _module_preset=”default” global_colors_info=”{}”]In the Previous Article What is Excel Macro<\/a><\/strong> of Excel Macro Tutorial<\/a><\/strong>, you have read, what is Macro<\/strong>, How to Record Macro<\/strong> and How to Run Macro<\/strong>.<\/p>\n

Before starting writing Macro in Excel 2007\/2010, we need a Developer Tab, where all the controls, options, and settings are there for Excel VBA. You can add the developer Tab in your excel 2007 or 2010 easily by going through the below-mentioned steps.<\/p>\n

Step by step guide to add Developer tab in Excel-2010<\/h2>\n
    \n
  1. Click on File<\/strong> of the Excel Workbook<\/li>\n
  2. Click on Option<\/strong><\/li>\n
  3. Go to \u201cCustomized Ribbon<\/strong>\u201d<\/li>\n
  4. In Right hand side in \u201cMain Menu<\/strong>\u201d Option check the \u201cDeveloper<\/strong>\u201d check box<\/li>\n
  5. Click OK<\/strong><\/li>\n<\/ol>\n
    \"Developer

    Developer Tab in Excel 2007<\/p><\/div>\n

    Step by step guide to add Developer tab in Excel-2007<\/h2>\n
      \n
    1. Click the Office Button<\/li>\n
    2. Click the Excel Option<\/strong> button at the bottom<\/li>\n
    3. Go to the Popular<\/strong> button at the left<\/li>\n
    4. Under Top Option for Working with Excel, check the Show Developer tab in the Ribbon<\/strong> option.<\/li>\n
    5. Click OK<\/strong> button to finish editing.<\/li>\n<\/ol>\n
      To Check out more Excel Macro Tutorials, visit Excel Macro Tutorial<\/a><\/strong><\/div>\n

      [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"

      Video : how to add the Developer Tab in Excel 2007In the Previous Article What is Excel Macro of Excel Macro Tutorial, you have read, what is Macro, How to Record Macro and How to Run Macro. Before starting writing Macro in Excel 2007\/2010, we need a Developer Tab, where all the controls, options, and […]<\/p>\n","protected":false},"author":45,"featured_media":244046,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1679,1684],"tags":[],"yoast_head":"\nExcel Macro Tutorial : Add Developer Tab in Excel - 2007 and 2010 - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"Complete guide to add Developer Tab in Excel 2007. How to add Developer Tab in excel 2010. Steps to add Developer Tab. Developer Tab is hidden\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Macro Tutorial : Add Developer Tab in Excel - 2007 and 2010\" \/>\n<meta property=\"og:description\" content=\"Complete guide to add Developer Tab in Excel 2007. How to add Developer Tab in excel 2010. Steps to add Developer Tab. Developer Tab is hidden\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2011-10-11T18:06:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-20T15:10:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/developer-tab.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1440\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Excel Macro Tutorial : Add Developer Tab in Excel – 2007 and 2010\",\"datePublished\":\"2011-10-11T18:06:52+00:00\",\"dateModified\":\"2022-08-20T15:10:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/\"},\"wordCount\":349,\"commentCount\":10,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"articleSection\":[\"Excel Macro Beginner\",\"Video Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/\",\"name\":\"Excel Macro Tutorial : Add Developer Tab in Excel - 2007 and 2010 - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"datePublished\":\"2011-10-11T18:06:52+00:00\",\"dateModified\":\"2022-08-20T15:10:51+00:00\",\"description\":\"Complete guide to add Developer Tab in Excel 2007. How to add Developer Tab in excel 2010. Steps to add Developer Tab. Developer Tab is hidden\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro Beginner\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-macro-beginner\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Macro Tutorial : Add Developer Tab in Excel – 2007 and 2010\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/twitter.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel Macro Tutorial : Add Developer Tab in Excel - 2007 and 2010 - Let's excel in Excel","description":"Complete guide to add Developer Tab in Excel 2007. How to add Developer Tab in excel 2010. Steps to add Developer Tab. Developer Tab is hidden","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:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/","og_locale":"en_US","og_type":"article","og_title":"Excel Macro Tutorial : Add Developer Tab in Excel - 2007 and 2010","og_description":"Complete guide to add Developer Tab in Excel 2007. How to add Developer Tab in excel 2010. Steps to add Developer Tab. Developer Tab is hidden","og_url":"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2011-10-11T18:06:52+00:00","article_modified_time":"2022-08-20T15:10:51+00:00","og_image":[{"width":2560,"height":1440,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/developer-tab.png","type":"image\/png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Excel Macro Tutorial : Add Developer Tab in Excel – 2007 and 2010","datePublished":"2011-10-11T18:06:52+00:00","dateModified":"2022-08-20T15:10:51+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/"},"wordCount":349,"commentCount":10,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"articleSection":["Excel Macro Beginner","Video Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/","url":"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/","name":"Excel Macro Tutorial : Add Developer Tab in Excel - 2007 and 2010 - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"datePublished":"2011-10-11T18:06:52+00:00","dateModified":"2022-08-20T15:10:51+00:00","description":"Complete guide to add Developer Tab in Excel 2007. How to add Developer Tab in excel 2010. Steps to add Developer Tab. Developer Tab is hidden","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro Beginner","item":"https:\/\/vmlogger.com\/excel\/excel-macro-beginner\/"},{"@type":"ListItem","position":3,"name":"Excel Macro Tutorial : Add Developer Tab in Excel – 2007 and 2010"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/twitter.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12071"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12071"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12071\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/244046"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}