"count" wrote in message ...
Hi,
I need to ensure that users keep updating software in VBA. So I need to warn
them, say 1 month in advance and past that, I need to disable their access
to crucial module.
I thought of removing that module. How do I do that programmatically?
TIA
Paul

Rather than bothering to unload the xla I would just make sure that
all the functions generate an error, or return #Value, if it is out of
date.

To return #Value use the following:

Public Function FunctionErrVal() As Variant
FunctionErrVal = CVErr(2015)
End Function