You have made the cardinal sin, you have merged the business logic and the
data into a single workbook. You should separate them, then any updates to
your addin are easily implemented.

I would suggest that you bite the bullet, break the application up, and
visit every user and break the data out. It will be time consuming to start,
but it will pay dividends in the future.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Madiya" wrote in message
...
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.