Default Macro

[Kinjalip]

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

 

[Dave Peterson]

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.