Dave suggested I post my request here. The post is also at:
Some time ago, during last year, I had a post like this. It was
partially answered, but I then stopped it because, mainly, it bordered
on creating a virus, someone thought.
I am, however, seriously considering distributing workbooks via the
e-mail system and want to
1) prevent clientA from forwarding it to non-paying clientB (I may make
use of ReadNotify.com's feature that prevents this (From what I read!)).
2) I also want to prevent clientA from being able to copy the file to a
distributable medium such as a CD (in other words, onto a drive with
another character (C to D)) BEFORE it has been opened. After it has been
opened, Registry entries will be imprinted in the file, rendering it
useless on other machines even if is saved for personal use. (For those
of my abilities, that is!!)
Deleting the attachment, in the end, may be circumvented by the above,
but any views on this will be welcomed. I may still need the attachment
and/or e-mail deleted upon first opening of the attachment (Excel file)
and the VBA code that does this then stopped once the deletion is
confirmed. BTW, "Delete" should read "Kill" - kept out of any Deleted
Folder / Recycle Bin.
Is it possible to do either (both, preferably!) of the requests 1) an 2)
Kindest possible regards
** Posted via: http://www.yqcomputer.com/
Excel Templates, Training, Add-ins & Software!