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
|