Store the macro in your personal.xls file.
http://www.vbaexpress.com/forum/arti...ticle&artid=18
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"James Proctor" wrote in message
...
Hi,

I would like to be able to open excel and have a macro that opens
automatically, so I can use it on any file that I open. Is there a way of
doing this? Im sure I've done it before, i just cant find how todo it
again.

Regards

James