Default Macro
Is there a way to add a Macro to Excel so each time you open up a blank xls
you can use the Macro? If so where can you place the macro so you would have it each time. thanks -- Jeffrey L. Lippard, A+ certified, CHDP certified |
Lots of people use a workbook named personal.xls in their XLStart folder for
this. If you record a macro and record it into personal.xls, then close excel, you'll see that excel saves it into your XLStart folder--and it saves it as a hidden workbook (so it doesn't bother the user). After it's created, you can add as many macros as you want. Kinjalip wrote: Is there a way to add a Macro to Excel so each time you open up a blank xls you can use the Macro? If so where can you place the macro so you would have it each time. thanks -- Jeffrey L. Lippard, A+ certified, CHDP certified -- Dave Peterson |
All times are GMT +1. The time now is 11:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com