How To Enable The Developer Tab

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 qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.


Related Posts



Get the Latest Microsoft Excel Tips

Follow Us

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