Hi,

You have to change the workbook in which the macro resides into an xla-file
(add-in). Now add it to the add-in list ToolAdd-insBrowse to get it into
your list, and ensure that the check box is ticked before closing the
dialogue box. Every time you subsequently open XL the add-in will load.

Just make sure your code is water-tight before you do this.

Here are a few links to get you started.

http://j-walk.com/ss/excel/faqs/xl97faq7.htm
http://www.erlandsendata.no/english/...baaddinexcel97
http://www.cpearson.com/excel/xltools.htm

Regards
Paul


"A.M" wrote in message
...
Hi,

I've created a excel macro and I want to make it globally in excel. That
means that I have the macro any ttime that I open any excel file.

How do I do that? Any link to on line resource can help.

Thanks,
Alan