Deploy Your Excel Macros From A Central File
- Topics:
- Software tips
- Source:
- Microsoft
FREE Registration is required
Overview: By default, when you create a macro for a Microsoft Excel worksheet, that macro works only on that worksheet. This behavior is okay as long the macro automates tasks that are unique to that worksheet. But have you ever found yourself recreating the same macro on more than one worksheet? If you have (and even if you haven't), you can copy your macros to a worksheet called personal.xls. From there, your macros become available to you whenever you start Excel, and you can run them against the data on any open worksheet. This paper explains how to place your macros in a file called personal.xls and make them available each time you start Excel.
(Is this item miscategorized? Does it need more tags? Let us know.)
Format: HTML | Pages: 10
