Microsoft Office Tutorials and References
In Depth Information
4.7.2 Running Macros
We should also comment on what appears and does not appear in the Macro list box. All macros
that we write will appear in the Macros dialog box (as will all recorded macros). However, there
are a few variations. If we give the macro a unique name (within the context given in the "Macros
in" list box), then only the name of the macro will appear in the list box. If the name is not unique,
then it must be qualified by the name of the module in which the macro appears, as in:
Sheet5.ScrollChartTypes
in Figure 4-12 . Unfortunately, the first version of a macro with a nonunique name is not qualified.
(Note the presence of another ScrollChartTypes macro in Figure 4-12 . )
Note that we can prevent a macro procedure from appearing in the Macros list box by making the
procedure private, using the Private keyword, as in:
Private Sub HideThisMacro()
We will discuss Private and Public procedures in Chapter 6 .
Finally, if you are like me, you will collect a great many macros over the years. As time goes by,
you may forget the names of some of these macros and thus have trouble finding a macro when
you need it. I would advise you to give some careful thought to creating a consistent naming
convention for macros. I begin the names of all macros with a word that categorizes the macro.
For instance, all of my macros that deal with worksheets begin with the letters Wks, as in:
Wks_Sort
Wks_Compare
Wks_Print
 
 
Search JabSto ::




Custom Search