Hi guys,

I have been searching for some time now for a way to be able to expire/auto-destruct so to speak certain types of sheets I would be passing around after a certain time/date, and about 2 days ago I came across this page -- http://www.cpearson.com/excel/workbooktimebomb.aspx -- which basically lists multiple “TimeBomb” methods of exactly doing this.

I have read the whole page and also downloaded the sample provided sheet that contains the VBA codes so I could try and make it work on my own, but unfortunately since I don’t know much in Excel programming or VBA was not able to which is why I am posting this here now.

I would be looking to use the “TimeBomb With A Defined Name” which is the first offered method of doing it on the page along with the extra option titled “TimeBomb With Suicide” which consists of an extra couple of lines you can add to have the sheets self-delete themselves after having passed their set dates.

What I am not sure of now is which variables am I supposed to edit here to have this work properly, as well as how/where am I supposed to place these codes for them to take effect on the sheets I would like to have them applied to.

All and any help is greatly appreciated, thanks.
Eric