Auto-delete the workbook on expiry
Yes that can be done, but very easy to get around, what if they open the
book with macros disabled?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"SuperJas" wrote in message
...
Hi,
I'm sending out a time-restricted Excel workbook for others to use, and
I'd like the file to auto-delete itself if it's already expired. Is this
possible to do in VBA? For example, if it's possible, the code could reside
in the Workbook_Open event, where a msgbox will pop up to tell the user the
file's expired (done), and then delete the file.
Thanks heaps for your help,
SuperJas.
|