The “Developers” toolbar (2007/2010) and the “Tools” (2003 and before)

In the 2007 and 2010 we need to open the “Developer” toolbar before we can start working with macros.

In the 2007 version, click the “Office button” and select “Excel Options”.
Then choose the “Popular” tab (1) and select the box for the text “Show Developer tab in the Ribbon” (2).

In the 2010 version, click the “File” button, click “Options”, choose “Customize Ribbon” and select the main “Developer” tab.


In both cases it shows “Developer” tab at the top of the Ribbon. Under the “Developer” tab we find all the buttons that we may need to use for macros and Visual Basic to work.

It is useful that we can hide “Developer” tab when we are not working with it, as it is a little messy to work with Macros and VB code.

In version 2003 and earlier, we do not have this ability. In those versions, we find the options for macros and Visual Basic under “Tools” and they are always accessible to everyone.

The keyboard shortcuts (1), such as Alt F8 for Macros and Alt F11 for the Visual Basic Editor, are still the same for versions 2007 and 2010. Nothing changed.

What has also not changed is the window to record macros (B), the window for the Visual Basic Editor (A) and the window for the different macros used (C).`


You've completed Lesson 3