As a starting point for a design...

* Create a sheet called "Licence" and password protect it

* Create the app sheets and password protect them

* In the Workbook Open event

...* Check if the registry 'Expired' value is set to true
......If it is
.........put out a message
.........close the worksheet

...* Check if the 'expiry date' cell is blank
......If it is
.........unprotect the sheet
.........set that cell to the expiry date
.........protect the sheet
.........save the file

...* Check if the current date/time is greater than the 'last used'
cell
......If it is
.........set the registry 'Expired' value to true
.........put out a message
.........close the worksheet

...* Unprotect the app worksheets

* In the Workbook BeforeClose event
...* Password protect the app worksheets

Gaz


--
gazornenplat
------------------------------------------------------------------------
gazornenplat's Profile: http://www.excelforum.com/member.php...o&userid=24494
View this thread: http://www.excelforum.com/showthread...hreadid=380883