Suggestions for creating a demo spreadsheet that locks up after atrial

[travis]

Someone has expressed an interest in paying me a monthly fee for use
of a financial planning spreadsheet I developed. First though, he'd
like to trial it for a week.

In order to prevent continued use after that week, I'd like to program
a lock up into it. I'd like to make all cell formulas hidden and then
make the spreadsheet read only and uncopyable after seven days.

Any suggestions for the best way to go about doing this in as
unobstrusive a manner as possible?

Travis

 

[Niek Otten]

Hi Travis,

Look here:

http://www.cpearson.com/excel/workbooktimebomb.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Someone has expressed an interest in paying me a monthly fee for use
| of a financial planning spreadsheet I developed. First though, he'd
| like to trial it for a week.
|
| In order to prevent continued use after that week, I'd like to program
| a lock up into it. I'd like to make all cell formulas hidden and then
| make the spreadsheet read only and uncopyable after seven days.
|
| Any suggestions for the best way to go about doing this in as
| unobstrusive a manner as possible?
|
| Travis

 

[NOPIK]

Try to use document constants (sheets number, creation date, etc) in
formulas, especially expiration date (like, =MyRange*(1-
INT(days(today();startdate)/7)))
This will make table useless after trial period, or if it will be
transferred.