Run macro on all files

[Romulo Avila]

Good Morning,


I have a macro that sends email's to certain addresses, I would like to know how I can make this macro available so that it can be used in all excel files, since today this frame is only accessible in the spreadsheet containing the code.


Thank you.

[Paul_Hossler]

1. Save it to your XLSTART folder, or

2. Make it an add-in (XLAM)

There will most likely be some compatibility changes you will need to make, the most common one being careful with 'ThisWorkbook' and 'ActiveWorkbook'