O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using a Macro in Other Workbooks

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required