prevent to use addin

[Gazeta]

hi
is there a way to prevent from usage of addin that was created before given
date?
i want user to be able to use only the last addin i sent him
thanks
mcg

 

[Harlan Grove]

Gazeta wrote...

is there a way to prevent from usage of addin that was created before given
date?
i want user to be able to use only the last addin i sent him

Not easily. An older add-in would need to know how to check if it were
superceded. That would be rather difficult. If your add-in were being
used by other files you or someone other than your end users designed,
then you could add a udf to the add-in that would return the add-in's
version label. Then your workbooks could call the version udf to check
whether the end user were using the latest version of the add-in, and
if not return errors and display dialogs informing the user of the need
to update the add-in.

If end your users are using your add-in in their own workbooks, then
there's no good way to ensure they're using the latest version other
than to force copies of the latest version onto their machines. That
poses security issues that are off-topic in Excel newsgroups.

 

[Gazeta]

Gazeta wrote...

Not easily. An older add-in would need to know how to check if it were
superceded. That would be rather difficult. If your add-in were being
used by other files you or someone other than your end users designed,
then you could add a udf to the add-in that would return the add-in's
version label. Then your workbooks could call the version udf to check
whether the end user were using the latest version of the add-in, and
if not return errors and display dialogs informing the user of the need
to update the add-in.

If end your users are using your add-in in their own workbooks, then
there's no good way to ensure they're using the latest version other
than to force copies of the latest version onto their machines. That
poses security issues that are off-topic in Excel newsgroups.

thanks for your reply
i think i found solution
my addin is designed for only one file
i have several sheets in it some of them veryhidden
procedures in addin process data stored in one sheet
so each time procedure starts it puts date of my addin somewhere on the
sheet ( that way i create list of dates )
then i check if that date is older than the latest one on created list
if so msgbox appears and says to install lates addin
if not other procedures might be run
list of dates cannot be deleted by user because it is hidden
what do you think about that?
mcg