Datasheet

Macro Basics
706
cell. Next, click the Bold button and then click 16 on the Font Size drop-
down list on the Home tab. Finally, drag through cells A1:E1 to select
this range and then click the Merge and Center button, again on the
Home tab.
After you finish taking all the actions in Excel that you want recorded
(See Figure 1-2), you’re ready to shut off the macro recorder.
10. Click the Stop Recording button on the Status bar or on the Developer
tab of the Ribbon.
The square blue Stop Recording button on the Status bar and the Developer
tab change back into circular red Record Macro buttons, letting you know
that the macro recorder is now turned off and no further actions will be
recorded.
Figure 1-2:
Recording
the actions
for the
Company_
name in the
worksheet.
Figure 1-1:
Getting
ready to
record the
Company_
name macro
in the
Record
Macro
dialog box.
36_037385 bk08ch01.qxp 11/29/06 1:13 PM Page 706