How to automaticlly disable a spreadsheet after a period of time

[Elvis]

Hi,

I have a workbook that I need to distribute to some people. However after six months of a given date (e.g today's date), I want the user to be unable to use it/open it.

For examplewhen the user opens it, it shows a message box saying "The Version as Expired, please contact X for latest version" . And then I want the workbook to close, either automatically or after the uses clicks OK after the message box.

Would this be easy to do or would it involve a lot if time writing the code for it?

Thanks,

Elvis

[lucas]

It would be next to impossible and could be easily cracked anyway. If you want to build an application that's secure you will have to use visual basic not vba.

[mdmackillop]

You could try this (http://www.vbaexpress.com/kb/getarticle.php?kb_id=475). The attached sample file will not open though, due to site problems.

[royUK]

There's some sample code here

http://www.thecodecage.com/forumz/local_links.php?catid=2&linkid=3