How to automatically add the Excel Add-in by clicking the add-in

Dear all,

Could you please help me, to automatically add the Excel Add-in by clicking the add-in, so that the custom menus gets created, instead of adding through the Tools->Add-Ins.

Thanks
Elango

Welcome to the Forums.

Thread Moved

What type of addin? xla or dll? Why would you need tit to automatically install itself?

I have created the custom menus through xla and distributed it to users. Different versions of the same xla file name will confuse the users to identify whether the added xla is the updated one and they feel tough in adding the add-in.

What i need is, if i click the xla file it will automatically add it into the add-ins and execute the worbook_open().

Or any other way to add the xla add-in by double clicking.

Please let me know, if this is not clear.

Thanks
Elango