Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Excel VBA: Display 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 they have changed the way of enabling the ribbon.

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.













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












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

 


This post first appeared on LazerWire.com, please read the originial post: here

Share the post

Excel VBA: Display the Developer Toolbar or Ribbon

×

Subscribe to Lazerwire.com

Get updates delivered right to your inbox!

Thank you for your subscription

×