MS-Excel / General Formatting

Displaying the Developer Ribbon

Macro making is made much easier with the use of the Developer ribbon, a special toolbar designed to help you with creating, running, and revising your macros. You can access some of the macro commands from the View toolbar, but you'll find your macro experiences will be much easier if you have the Developer ribbon on display.

Follow these steps to add the Developer ribbon to your Excel screen:

  1. Click the Office button in the top-left corner of your Excel screen. The Office menu appears.
  2. Click the Excel Options button at the bottom of the menu window.
  3. Make sure the Popular optionis highlighted on the left side of the Excel Options window and then Click to check the box Show Developer Tab in the Ribbon.
  4. Click OK. The Developer ribbon is now available to you by clicking the Developer tab at the top of your Excel screen.

Note that the Developer ribbon is now a permanent part of your Excel ribbon choices. Should you decide you no longer want to have access to the Developer ribbon, you can go back to the Excel Options window and uncheck the box for the Developer ribbon.

[Previous] [Contents] [Next]

In this tutorial:

  1. Excel Macros
  2. What You Can Do with VBA Macros
  3. Introducing macros
  4. Displaying the Developer Ribbon
  5. Creating a Macro
  6. Running a Macro
  7. Assigning Macros to the Quick Access Toolbar
  8. Using a Function Macro
  9. Saving and Deleting a Macro
  10. Macro virus protection
  11. Macro Key Tips