I would caution you to consider the impact of "burning your bridges" as
it were. If you screw with this client, not only do you assure they
will <never utilize your services again, you also assure that they
will give you bad word of mouth advertising.

A better idea may be to turn this into a PR plus. Let them know you
are not "locking down" your spreadsheets and that they are free to
continue to utilize them. Most likely the new vendor will have their
own system anyway, and won't need or want to utilize yours (they
probably sold themselves as having a better system). Plus, all they
need is a backup laying around once they figure out what you've done,
alter the system date on a pc, open the file and modify your code....

Just my opinion, for what its worth...

Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=399016