P.S. My reason for saying the answer is no is that VBA code can be defeated
pretty easily for password protection. You can write code to do what you
described but it is of limited value in protecting against illegal useage if
the companies staff are not reputable. If they are reputable, then the
billing procedure would work just as well.

" wrote:

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