Microsoft Office Tutorials and References
In Depth Information
Running a Macro
If you are working in a later version of Excel, click the Stop Recording button from the Developer
tab in the Ribbon, as shown in Figure 2-15. Clicking the Stop Recording button ends the recording
session, and you will have created your macro.
figurE 2-15
HEy, My sTop rEcording BuTTon disAppEArEd!
If you are using Excel version 2003 or before, the Stop Recording toolbar might
seem to suddenly disappear on you from time to time. This is almost always due
to unwittingly closing that toolbar by clicking the “X” close button on its title bar
instead of the Stop Recording button. It happens to the best of us. To show the Stop
Recording toolbar again, start to record a new macro, then from the worksheet
menu click View Toolbars Stop Recording. Click the Stop Recording button to
end the macro, and the next time you record a macro, the Stop Recording toolbar
will be its normal visible self.
running A MAcro
You have many ways to run a macro, most of which are demonstrated in later lessons. As you will
see, the method(s) you choose for running your macros may depend on complex reasons such as the
workbook design, or may be based on a simpler factor such as what feels most intuitive and
convenient for you. To wrap up this lesson, following are a couple of commonly used options for running
your macros.
The Macro dialog Box
When you create recorded macros, their names will appear listed in a
dialog box called, appropriately enough, the Macro dialog box. To show
the Macro dialog box in version 2003 or before, click the Run Macro
button on the Visual Basic toolbar as shown in Figure 2-16. The title of
that button, Run Macro, is a bit of a misnomer, because just by clicking
figurE 2-16
 
Search JabSto ::




Custom Search