Microsoft Office Tutorials and References
In Depth Information
Saving a Macro to the Personal Macro Workbook
1.
When you begin to record
a macro, click the down
arrow by Store macro in.
You’ll see the options
shown in Figure 11–12.
Figure 11–12. How to store a macro in the Personal
Macro Workbook
2.
Click Personal Macro Workbook and OK, and then record the macro as
usual.
You don’t even have to save the actual workbook in which you’ve devised the macro,
because the macro is being saved to the Personal Macro Workbook (but if you’re
prompted to save the Personal Macro Workbook itself, you should).
Now whenever you open any workbook and click View Macros View Macros, you’ll
immediately be presented with the macros saved to the Personal Macro Workbook (see
Figure 11–13).
Figure 11–13. All that’s left to do is click Run.
 
Search JabSto ::




Custom Search