Microsoft Office Tutorials and References
In Depth Information
What We’ve Done
3.
You’ll next see the Macro dialog.
Click Run, as shown in Figure 11–9.
The macro should execute
immediately and very swiftly—a lot
quicker than you could enter the
logo manually, in fact.
Figure 11–9. There’s the logo macro.
What We’ve Done
That’s basically it. Let’s quickly review the process:
1.
Enter macro-recording mode.
2.
Execute the commands on the worksheet you want the macro to
capture.
3.
Stop recording (you’ll want to remember this step, because if you
neglect to click the stop-recording button, all your subsequent
spreadsheet actions will be recorded to the macro, too).
When you’re ready to play the macro back, open the Macro dialog box shown previously
in Figure 11–9, click the name of the macro you want to execute (because you can
record multiple macros on the same worksheet), and click Run.
Relative References in a Macro
The macro we’ve just designed transports the cell pointer to A1, where it then begins the
process of automatically entering the logo. And by default the macro will always travel to
cell A1, and then start to do its thing.
Well, of course it will, you’ll likely reply; isn’t that exactly where we want the macro to
start? Yes it is—and what that means in turn is that no matter where the cell pointer
happens to be positioned before you trigger the macro, it will start back in cell A1 just
the same. If you’ve landed the cell pointer in cell ZA458102—or any other cell in the
 
Search JabSto ::




Custom Search