I produce a number of quite complex spreadsheets for a number of
clients. One client is due to change suppliers at the end of the year
and currently recieves a very large amount of management information
from us via the spreadsheets.

It might sound like "sour grapes" but after they change suppliers I do
not want the new supplier to simply pick up my spreadsheets and
continue to provide the same management information without having any
of the cost/headaches associated with producing the spreadsheets.

Is there a way, perhaps using the date, to set the formulas to
automatically delete themselves after a given date?

I have no problem with the format or data - it's just removing the
formulas.

Logic says I should have password protected the files in the beginning
... hindsight is a great thing!

I think that I am right in believing that I am not breaking any laws
etc. (and I certainly don't want to even think about viruii). The
iinformation is supplied as a service for which there is no charge.

Any advice would be appreicated.

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=399016