Store Macro In

The Store Macro In option tells Excel where to store the macro that it is recording. By default, Excel puts the recorded macro in a module in the active workbook. If you prefer, you can record it in a new workbook (Excel opens a blank workbook) or in your Personal Macro Workbook.

Your Personal Macro Workbook is a hidden workbook that opens automatically when Excel starts. This is a good place to store macros that you'll use with multiple workbooks. The Personal Macro Workbook is named personal.xls and it is created the first time you specify it as the location for a recorded macro.

0 0

Post a comment