VBA or Macro

[pooadrid]

im attempting to create a workbook, that basically expires itself.

id like this to no be visable on the sheets it self, but when a pre determined time or date comes up, the workbook will erase all content throughout and save. essentially making the workbook useless.


is this possible?

 

[Fennek]

Hi,

depending on the environment, it could be critical. Therfore just an idea:

- define a hidden name with the expire date
- in the workbook_open event compare with actual data

regards

 

[mole999]

In rough in a macro enabled workbook

On workbook open event

If preset date less than today exit sub
If preset date greater or equal to Today()

Add new sheet

delete all sheets not equal to the new one you have just created

Activeworkbook.save

then close


Most of this can be recorded with macro recorder, and then tweaked
If you can make sure that you do not save too much code in modules or thisworkbook, then most of the code will be deleted as well

 

[Joe4]

I am not sure why you want to do this, but here is one thing to consider.

We have gotten requests like this before, sometimes from people who wanted to do this to programs that they created for their company (sort of a "job security" thing - so that if they were fired, there programs would stop working at some point). Just bear in mind that sort of thing is illegal in most places, and you could be opening yourself up to some legal issues if you do. So, if that is what your intention is, I would strongly advise against it.

If that is not what you need this for, then you can disregard all of what I just said!