VBA Developer Tab in Excel is one of the most important Tab on the Excel ribbon. It is used to write macros, run macros, and to create user defined functions etc,. To enable VBA Editor window to write VBA codes, we click on developer tab or ‘Alt+F11’. Default the Developer-tab is not visible or shown on the Excel ribbon. In this tutorial we are going to see how to get/show the Developer-tab on the Excel ribbon. You can find here screen shots and step by step instructions for better understanding.
You can see default Excel ribbon without Developer tab in the following screen shot.
Here are the step by step instructions to show the Developer-tab in Excel
- Click on the File tab.
- Click on Options from the available options.
- Click on the Customize Ribbon from the Excel Options.
- Select Main Tabs under Customize the Ribbon.
- Under Main Tabs select the Developer check box.
- Click on OK.
- Now, you can see Developer tab on the Excel ribbon.
Follow above specified step by step instructions. Now you can click on the DeveloperTab from Excel ribbon to go to VBA editor window. As shown below in the screen shot, you can see DeveloperTab which is highlighted in red color.
Above specified instructions applies to all below specified New Versions of MS Office.
Excel MS Office 365, Excel 2016, Excel 2013, Excel 2010 and Excel 2007.
You can refer the following link for the step by step instructions.
Click on the following links of the useful resources. These helps to learn and gain more knowledge.