Developer Tab on the Excel Ribbon Menu

Home/VBA/Show Developer Tab in Excel Ribbon

Show Developer Tab in Excel Ribbon in MS Office tools helps programmer to navigate VBA editor, recording macros to automate repetitive tasks and to write VBA programs to develop applications. By default you cannot see the Developer Tab in any Office Applications (Excel, Access, Power Point, Word, Outlook etc.). You can enable and get the Developer Tab in different ways. Following are the simple steps to get the Developer Tab in the Excel Ribbon.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

In 2007:

Please follow the below steps to Show Developer Tab in Excel Ribbon in the MS Excel 2007.
1. Go To File menu
2. Click on Options from the file menu
3. Check the ‘Developer Tab’ from the options
Now you can see the Developer Tab in ribbon menu.

In 2010 and 2013:

Please follow the below steps to Show Developer Tab in Excel Ribbon Tab in the MS Excel 2010 or 2013.
Step 1: Right click on any main menu item in the Ribbon. Please find the below screen shot for the same.

Step 2: Click on Customize the Ribbon…, this will show you Excel options window.

Step 3: Now select the developer Tab from the Main Tabs list in the excel options window (Right Side). Please find the below screen shot for the same which is highlighted in yellow color.

Step 4: Click on Ok button.
Step 5: Now you can see the ‘Developer Tab’ in the Ribbon. Please find the below screen shot for the same which is highlighted in yellow color.

Now you can see the different tools in the ‘Developer Tab’ to deal with the VBA and macros.

You may find the below related topics:

record a Macro? You can record the macros from the developer tab to automate any repetitive task.
• How to Save the Excel Workbook as Macro File? Once you are done with the recording a macro or writing a procedure, you have to save the file in the macro enabled format to use in the future.
• How to Run a VBA macro? Once you are written a macro procedure, you can save the file. And can run the macro from the developer tab whenever you want to execute it.
• How to assign a shortcut key to run a macro? Alternatively, you can assign a short-cut key for executing any macro from the list of Macros in the developer tab.
• How to see the list of excel VBA macros available in the workbook? You can see the list of macros available in the workbook by clicking on the Macros command in the Developer Tab.
• How to change the VBA Macro Security levels? We can set and change the VBA Macro Security Levels using ‘Macro Security’ Command available in the Developer Tab.

Related articles:

Here the following link to disable or hide developr tab in Excel ribbon.
Hide Developer Tab

Here the following link to record macro in Excel VBA.
Record a Macro

By |March 8th, 2015|VBA|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment

Related pages

definition of merge in excelhow to learn vba codeunlock excel file with passwordshortcut key for excelpassword protection excel 2010excel vba userform combobox additempaste values vbahow to do carriage return in excelusing vba functions in excelconcatenate excellunprotect a worksheetautofit row height excel 2010sql interview questions with answers pdfsumifs excel 2007data definition language ddl commandunprotect workbook vbavba chart titlepivot table tutorial 2013duplicate numbers in excelhow to create dynamic charts in excelexcel 2010 hlookupvba data entryvba command buttoncode for comboboxgenerating xml from excellearn excel vlookupcombine multiple excel files into one worksheetradio buttons excelexcel vba save as xlsxhow to unprotect excel cellscode execution has been interruptedpurpose of pivot tables in excelvbcrlf in vbaadodb.connection openexcel developer ribbondml exampleline break in vbaconvert excel to csvsimple excel exercises for beginnersddl dml dcl tcl commands sql serverexcel 2007 userformexcel extract duplicatesvba last row in rangeprotecting worksheets in excelconsolidate excel workbooksms excel vbaadvanced pie charts in excelexcel project management templatesdefine chart in exceldata mining interview questions and answersforgot excel worksheet passwordhow do i copy cells in excelno of rows and columns in ms excelsimple vlookupsample excel macro codeexcel vba screen updateexcel macro looppassword protect excel 2010excel vb programmingdrop down lists in excel 2007excel vba sheet rangeexcel combine data from multiple sheets into one sheetsql technical interview questions and answerscell color in vbamerge excel files macroexcel chart formattingexcel lookup valuelistbox codedata validation in excel 2007 with examplebypass excel passwordhow to remove duplicate data in excel 2007sheet tab excelif statement excel macrohow to do pivot table in excelhow to unhide cells in excelmerge multiple worksheets into oneexcel formula corrector