Autorun Add-In

[A.M]

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

 

[Ron de Bruin]

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.

 

[Paulw2k]

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/index.php?d=envbaaddinexcel97
http://www.cpearson.com/excel/xltools.htm

Regards
Paul