One way would be to save a file with the macro as an add-in and
select it in the Tools/Add-ins... menu.


Another would be to put the macro in your personal.xls workbook or
another workbook that is stored in your XLStart folder.

In article ,
pini35 wrote:

I have written a vba macro.

I wish the macro to be present and usable everytime a new instance of
Excel is opened (e.g. like an add-in).

Anybody know how I do this? Please let me know if this request is not
clear, or if more information is needed.


Many thanks in advance.