Microsoft Office Tutorials and References
In Depth Information
Composing a Macro
as you would under normal data entry conditions. Once you’re done you can save the
macro and play it back whenever you wish. Let’s see how that works.
Composing a Macro
In order to see what macros have to offer,
let’s return to the example with which we
introduced the chapter. Your company
often identifies its workbooks by posting
its name and address somewhere near the
top of Sheet 1, something like what’s
shown in Figure 11–1.
Figure 11–1. It pays to advertise: Your company logo
Again, this set of information appears at the top of many of your spreadsheets, and
you’re getting slightly fed up with having to type it all those times.
That’s where the macro comes in, and here’s how it works:
1.
Click the View tab, choose Macros,
and then click the Macros drop-down
arrow, as in Figure 11–2.
Figure 11–2. Click that arrow to reveal the Macros
drop-down menu.
2.
Click Record Macro…, and you’ll see
the dialog shown in Figure 11–3.
Figure 11–3. The Record Macro dialog
 
Search JabSto ::




Custom Search