REAL-TIME

VBA Projects

Full Access with Source Code
  • Designed and Developed by PNRao

  • Full Access with VBA Source Code

  • Well Commented Codes Lines

  • Creative and Professional Design

Effortlessly
Manage Your Projects

120+ Project Management Templates

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

120+ PM Templates Includes:
  • 50+ Excel Templates

  • 50+ PowerPoint Templates

  • 25+ Word Templates

Share Post

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.

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.

Excel VBA Develoer Tab

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.

Excel Options VBA Develoer Tab

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.

Excel VBA Develoer Tab1

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:</h3
• How to open the VBA Editor? : As explained above you can enable and get the Developer Tab and you can write the macros by opening the VBA Editor.
• How to write a VBA macro? : You can write the macro procedures or functions by opening the VBA Editor.
• How to 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

Effortlessly Manage Your Projects and Resources
120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

Save Up to 85% LIMITED TIME OFFER
Project Management Templates

All-in-One Pack
120+ Project Management Templates

Essential Pack
50+ PM Templates

Excel Pack
50+ Excel PM Templates

PowerPoint Pack
50+ Excel PM Templates

MS Word Pack
25+ Word PM Templates

Ultimate Project
Management Template
Ultimate Resource
Management Template
Project Portfolio
Management Templates
Categories: VBATags: , , Last Updated: July 16, 2022

Leave A Comment