Default Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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