Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sharing a macro
I have created a macro in EXCEL and is part of my PERSONAL.XLS how do I do
this. One way I did it was just cut and past but there must be a better way. Thank You Charles |
#2
|
|||
|
|||
If you're going to share macros, you could create a new workbook named:
CharlesUtilities.xls Put all your macros that you want to share in that workbook. (Remove them from your personal.xls file, too.) Or if you want to share all your personal.xls, just rename it to CharlesUtilities.xls and share that workbook. Tell the recipients to put it in their XLStart folder (or open it when they need it). If you share your your macros using personal.xls, then you could be destroying their own version of personal.xls. Charles wrote: I have created a macro in EXCEL and is part of my PERSONAL.XLS how do I do this. One way I did it was just cut and past but there must be a better way. Thank You Charles -- Dave Peterson |
#3
|
|||
|
|||
Dave Thank You Very much!
"Dave Peterson" wrote: If you're going to share macros, you could create a new workbook named: CharlesUtilities.xls Put all your macros that you want to share in that workbook. (Remove them from your personal.xls file, too.) Or if you want to share all your personal.xls, just rename it to CharlesUtilities.xls and share that workbook. Tell the recipients to put it in their XLStart folder (or open it when they need it). If you share your your macros using personal.xls, then you could be destroying their own version of personal.xls. Charles wrote: I have created a macro in EXCEL and is part of my PERSONAL.XLS how do I do this. One way I did it was just cut and past but there must be a better way. Thank You Charles -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
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) | |||
Macro and If Statement | Excel Discussion (Misc queries) |