Myrna, that is a subtly useful idea. Since you mentioned it, I'm
inspired to split up my personal.xls, which over time bas built up to
dozens of subs and functions.

One side benefit is that I can shed the ones that are nothing but
"noise" to office colleagues (but that I myself could never part with
<g), and pass around a concise version that they would easily
comprehend and thus find palatable.

On Sun, 24 Aug 2003 20:45:02 -0500, Myrna Larson
wrote:

Actually it doesn't have to be in a file named Personal.xls. It just has to be in an XLS file
that you save in your XLSTART folder so it is loaded every time Excel starts up.


On Sun, 24 Aug 2003 20:57:42 -0400, "John Wilson" wrote:

Nick,

In order to have it available when you open Excel it'll have to
placed in your Personal.xls file.
Check the VBA Editor under the "Project" and see if it exists.
If not, go back to Excel and record a macro (any macro) and when
asked where to save it, choose "Personal.xls" (now you'll be able
to copy/move your macro into the Personal.xls).

For some more help with this, take a look he
http://www.mvps.org/dmcritchie/excel/getstarted.htm

John

"Mimmo" wrote in message
...
Just wrote my first VBA program now my question is: how do I save the code
so that it is available as a macro anytime I run Excel?
thanks
nick