hardeep.kanwar;288889 Wrote:
Sir, Is it possible to Replace Date With Time

Like: 00:00:30

that means After 30 Seconds it will Corrupted the Sheet ands will not
open even from the mail.

thanks in Advance
You cannot "corrupt" or whatever any excel file that is an attachment,
you can only manipulate it once its downloaded and opened, it is easy to
stop a macro running when opening Excel so if you are trying to protect
your workbook and contents this way you will be disappointed!

Timing is done via the ontime method as described at Chip Pearsons
site, the problem is if you allow them to view the workbook at all then
the sheets will be unhidden and they may crash the code and be able to
carry one viewing the workbook!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=80570