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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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.

thanks for the tip. found out about the save as .xla option.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/