Deactivate formula after a set time
 

Is it possible to set formulas to deactivate after a given period of
time?

I email out a number of spreadsheets that have taken many hours/days to
assemble to clients. If they choose to change suppliers (as one recently
did) they can simply use my spreadsheets and change the logos and the
new supplier gets all the benefits without the pain!

The value of the spreadsheets (the useful life of the data) is only a
few days so it would be useful if the formulas stopped working after
maybe a month.

Any ideas/suggestions would be appreciated

Tony


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=468448

Hi

Only possible if the user must enable macro's to use your workbook.
Is that true ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"y_not" wrote in message
...

Is it possible to set formulas to deactivate after a given period of
time?

I email out a number of spreadsheets that have taken many hours/days to
assemble to clients. If they choose to change suppliers (as one recently
did) they can simply use my spreadsheets and change the logos and the
new supplier gets all the benefits without the pain!

The value of the spreadsheets (the useful life of the data) is only a
few days so it would be useful if the formulas stopped working after
maybe a month.

Any ideas/suggestions would be appreciated

Tony


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=468448