Excel VBA: Displaying the Developer Toolbar or Ribbon

Microsoft Excel3 Comments on Excel VBA: Displaying the Developer Toolbar or Ribbon

Excel VBA: Displaying the Developer Toolbar or Ribbon

By default the developer toolbar or ribbon (depending on the Excel version) is hidden in Microsoft Excel. In Excel 2007 and later it can be quite tricky to figure out where to enable the developer ribbon if you don’t know where to look. To make things even worse, in Excel 2010 and Office 365 they have changed the way of enabling the ribbon.

Excel 2016 (Office 365)

In Excel 2016 (O365) you can display the developer ribbon the following way:

  1. Click File on the main toolbar
  2. Press Options in the bottom left corner
  3. Make sure that the Customize Ribbon right menu item is selected.
  4. In the dropdown list called Customize the Ribbon, select All Tabs.
  5. In the group called Main Tabs, make sure that the option Developer is checked.
Displaying the Developer ribbon in Excel 2016 (Office 365)

Excel 2010

In Excel 2010 you can display the developer toolbar the following way:

  1. Click the green File Button
  2. Press Options
  3. Make sure that the Customize Ribbon right menu item is selected.
  4. In the dropdown list called Customize the Ribbon, select All Tabs.
  5. In the group called Main Tabs, make sure that the option Developer is checked.
Display the Developer ribbon in Excel 2010
Displaying the Developer ribbon in Excel 2010


Excel 2007

To display the developer ribbon, do the following:

  1. Click the Office Button
  2. Click the Excel Options button at the bottom of the dialog.
  3. Ensure that the Popular tab in the left menu is selected (se picture below)
  4. Check the option Show Developer tab in the Ribbon
Displaying the Developer ribbon in Excel 2007


Excel 2003

In older versions of excel the developer ribbon is divided between two toolbars: Control Toolbox and Forms. The toolbars can be displayed the following way:

  1. Press View on the main toolbar
  2. Select Toolbars
  3. Check the toolbar Control Toolbox
  4. Check the toolbar Forms
Displaying the Developer toolbar in Excel 2003
Displaying the Developer toolbar in Excel 2003

 Related

Ulf Emsoy has long working experience in project management, software development and supply chain management.

3 thoughts on “Excel VBA: Displaying the Developer Toolbar or Ribbon

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top


Subscribe to our newsletter