How to enable developer ribbon in Excel?

developer ribbon in Excel

Do you want to enable developer ribbon and use VBA in Excel? Follow these simple steps:

Step 1: Right click any ribbon name

Step 2: Select “Customize Ribbon”

Step 3: This opens the Excel Options. From here, Check the “Developer” option in the right side panel

Adding / enabling developer ribbon in Excel with ribbon options

Step 4: Click ok.

Your developer ribbon is now enabled. You can use it to record macros, view VBA Editor and customize code. You can use the developer ribbon to access form controls or spreadsheet properties window.

See the whole process in this quick video.

Related: How to use VBA in Excel?

If you want to learn VBA coding, check out my free 4 part VBA tutorial. Learn how to write macros and build automations with VBA in Excel.

  • Part 1: What is VBA and how to get started with it in Excel?
  • Understanding variables, conditions in VBA
  • How to use cells, ranges and objects in VBA
  • Your first VBA Project – a full app with Excel

The post How to enable developer ribbon in Excel? appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Original source: https://chandoo.org/wp/how-to-enable-developer-ribbon-in-excel/

Tags: , ,
Close Menu