Gazornenplat,

To be or not to be.

--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"gazornenplat"
wrote in message
news:gazornenplat.1qzvme_1119388023.5956@excelforu m-nospam.com...

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