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 DeveloperTab is not visible or shown on the Excel ribbon. In this tutorial we are going to see how to get/show the DeveloperTab on the Excel ribbon. You can find here screen shots and step by step instructions for better understanding.
VBA Excel Ribbon W/O Developer Tab:
You can see default Excel ribbon without Developer tab in the following screen shot.
Show the Developer Tab in Excel:
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.
Excel Ribbon with Developer Tab:
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.