There is no really good way to do this. Any protection scheme can be
defeated by a user with an intermediate level of competence in Excel. That
said, you might find the code on
http://www.cpearson.com/Excel/WorkbookTimeBomb.aspx useful.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

wrote in message
ups.com...
I need some advice. I have a customer that uses an excel spreadsheet
to figure wealth and other money related items. Anyhow it is a large
formula that he wants to lease out to companies with a year lease.

After a year he wants it to expire and then the company would have to
contact and pay for another year subscription. Is there a way to lock
an xls to 365 days then have some sort of code / password to give them
for another years use?


Email me at

Thanks All