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

Hi

You can your personal.xls file or save a workbook with the code as a addin.

If you want to use the macro in all your workbooks you can copy the macro in
your personal.xls.
This is a (normal) hidden workbook that is loaded automatically by Excel.
When you record a macro, you have the option of recording it to your
Personal Macro Workbook.
The file, Personal.xls, is stored in your \XLStart directory.

The easiest is to record a dummy macro and choose Personal Macro Workbook.
Excel create the file for you this way.
Then copy your macro in this file and delete the dummy macro.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"A.M" <(E-Mail Removed)> wrote in message news:OFSW6s%(E-Mail Removed)...
> 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
>
>

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 Tool>Add-ins>Browse 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" <(E-Mail Removed)> wrote in message
news:OFSW6s%(E-Mail Removed)...
> 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
>
>