How To Enable The Developer Tab

2017-01-02

VBA

If you’re going to be using VBA or recording macros in Excel then you’re probably going to want to add the Developer tab to your Ribbon. By default Excel’s Developer tab is hidden and you will need to go into the options to enable it. The Developer tab will allow easy access to various features not otherwise accessible.

  • Open the visual basic editor (VBE) from the ribbon.
  • Record macros.
  • Run your recorded macros.
  • Add in form controls such as combo boxes, check boxes, radio buttons etc…
  • Manage your Excel Add-Ins.

 

 

Enable the Developer tab.

  1. Go to the File tab.
  2. Click on Options.
  3. In the Excel Options window, click the Customize Ribbon section.
  4. Make sure Developer is checked.
  5. Press the OK button.

 

 

Your ribbon now has the Developer tab and you can access various VBA related items easily from the ribbon.

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.

Subscribe

Advertisement

Related Articles

Comments

0 Comments

Get The Latest News

Follow Us

Follow us on social media to stay up to date with the latest tips in Excel!

Pin It on Pinterest

Share This