It's important to know what goes on behind the scenes when you create a macro. When you create a macro, Excel stores your keystrokes and mouse actions as a set of instruction on a macro sheet. You can tell Excel to store the instructions in one of the following places:
The active workbook
A new workbook
Personal Macro workbook
Excel stores your macro in the active workbook by default. If your macro works only on the current workbook, store the macro in the active workbook. If your macro works in a new workbook, create a new workbook and store your macros there. If your macro works on any workbook in Excel, store that macro in the Personal Macro workbook. The macros in a Personal Macro workbook are available every ...