How do I make a macro present (like an add-in) on opening Excel?

  • Thread starter Thread starter pini35
  • Start date Start date
P

pini35

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.
 
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.
 
Back
Top