| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
| Date macro | Excel Discussion (Misc queries) | |||
| Where to stick macro to change default comment font? | Excel Discussion (Misc queries) | |||
| how to attch a macro to the default wookbook? | Setting up and Configuration of Excel | |||
Linear Mode
