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