Using the Personal Macro Workbook

When you recorded the CompanyAddress macro earlier in this chapter, you placed the macro in a module that belonged to the active workbook. A macro you place in a module is available only when you open the workbook containing the module.

To make a macro available at all times, store it in the Personal Macro Workbook. This workbook is ordinarily hidden; you can unhide it by clicking Unhide in the Window group on the View tab and then selecting PERSONAL in the Unhide dialog box. If the Unhide command is unavailable, you have not yet created a Personal Macro Workbook. To create one, begin recording a macro, as described earlier in this chapter, and then select Personal Macro Workbook in the Store Macro In drop-down list in the Record Macro dialog box. Excel creates the Personal Macro Workbook and places its file (Personal. xlsb) in the XLStart folder. Excel opens Personal. xlsb, as it does any other file in the XLStart folder, each time you start Excel. It's a good place to record macros that you want to be able to use in any workbook.