I am preparing to distribute a program throughout my company that I created and to minimize it being taken to competitors I would like to include code that causes access to the program to be denined every 120 days until a password is given.

Any suggestions??

Hi
though you can put some code in your macro to achieve this
it's quite easy (takes only a minute) to circumvent
this 'security'.
Excel is not really able to provide/develop secure
applications. The best thin you could do is create a COM
Addin and put this kind of code within this add-in

-----Original Message-----
I am preparing to distribute a program throughout my
company that I created and to minimize it being taken to
competitors I would like to include code that causes
access to the program to be denined every 120 days until a
password is given.

Any suggestions??
.

Bruce -

While it could easily be circumvented by someone who knows what they're
doing, such people are few and far between (present company excepted).

I've used this, and it seems pretty robust:

http://www.andreavb.com/tip080006.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

bruce forster wrote:

Frank:

Thanks for the comments. I understand it could be circumvented but
can you provide some code anyway that would require a password every
120 days??

Thanks.