Hi Madiya,

One way would be to write some code in another book that updates the
code in your addin. You could then just assign that to the
Workbook_Open event of the new book so that all you have to do is send
it to the users, they open it and close it and all is done. Actually
you could also make it close itself even (remember to programatically
save the addin).

info can be found he http://j-walk.com/ss/excel/tips/tip61.htm

Cheers,
Ivan.

On Mar 27, 6:06*pm, Madiya wrote:
I have a addin used by several users. One of the sheet in addin is
used for recording data.
Now I have added some more functions and want to distribute the same
to users.
I can not ask users to just replace addin file coz it will affect the
existing records.
Also only one or two module is updated and rest of the module and
forms are same.
Problem here is that users are not experts and may goofeup.

Is there any way I can do it automatically?
Or any other better way?

Regards,
Madiya.