it could be done but only on any new spreadsheets you send them.
wouldn't they have all the older spreadsheets you sent them? the older
spread sheets would still have the formulas.

regards
FSt1


"y_not" wrote:


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