Hi Dave !!
you could write a workbook-open event procedure that
colours all the sheets in your workbook BLACK and also closes the workbook,
on the 'expiry' date. That will do the trick !! But don't tell your employees
how you did it !!

"dave.d71" wrote:

im putting together a workbook that i use to track performance of staff.
i want to code in somehow a future expiry date so that it can no longer be
used.
this is to prevent others from coping my hard work in design etc. and just
use it for their own benifit if they were to leave or move to a competitor.