Microsoft® Office Excel® 2007 Inside Out

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 ...