Microsoft Office Tutorials and References
In Depth Information
Lesson 2: Getting Started with Macros
For versions of Excel up to and including 2003,
from your worksheet menu, click View ➪
Toolbars ➪ Visual Basic as shown in Figure 2-1.
This displays the Visual Basic toolbar, as shown
in Figure 2-2, which you can dock just as you do
with your other toolbars.
For versions of Excel after 2003 (that is,
starting with Excel 2007), the Ribbon user interface
has replaced the menu interface, resulting in a
different look to the VBA-related icons and a
different set of steps required to see them.
In versions 2007 and 2010, these VBA icons
are located on the Developer tab. By default,
the Developer tab is not automatically
displayed along with the other Ribbon tabs. You
need to do a set of one-time mouse clicks to
show the Developer tab, and to keep it visible
whenever you open Excel. Although the steps
to do this are easy, they are different between
versions 2007 and 2010.
In Excel 2007, click the round Office
button near the top-left corner of
your screen. Then, click the Excel
Options button located at the bottom
of that menu, as shown in Figure 2-3.
In the Excel Options dialog box, click the Popular item at the
upper left, and select the Show Developer tab in the Ribbon
option, as shown in Figure 2-4.
For Excel version 2010, showing the Developer tab is a bit
different. A new Ribbon tab named File has supplanted the Office
button. Click the File tab and then click the Options button as
shown in Figure 2-5.
In the Excel Options dialog box for version 2010, click the
Customize Ribbon item at the left, which displays two vertical
lists as shown in Figure 2-6. Notice that the list on the right
a drop-down menu above it called Customize the Ribbon.
Select the Main Tabs item from that drop-down. In the list of
Main Tabs, select Developer and click OK.