expiry date

[freshbreath]

good morning

i want to set up a spread sheet that has an expirty date of 30 days and once reached the spread sheet can no longer be read

[dominicb]

Good morning freshbreath

i want to set up a spread sheet that has an expirty date of 30 days and once reached the spread sheet can no longer be read

You want to timebomb a workbook. There is a comprehensive article by Chip Pearson on that very subject here. However, pay extra special attention to the paragraph about Excel's security being weak. This kind of thing can be circumvented very easily by a knowledgable user, and there is no way of zipping a workbook up that tightly that it can't be reversed. Just something to consider ...

Good luck!

HTH

DominicB

[go2review]

had a look and im very new to this and not sure. i like the suicide one but not sure where i put the days part of the coding

[go2review]

can anyone help me put a formula in so the spread sheet terminates after a given time span

[royUK]

You cannot do it with a formula. If I recall Chip Pearson tells you how to do this. Here's an example that might help

[go2review]

thank you for your help but this is beyond me and im struggling to understand

[royUK]

I've put notes in the VBA, you just need to change the number of uses to a date. I'm not sure what else can help you need a little basic VBA knowledge to attempt to do something like this.

[royUK]

This example stores the start date the first time the workbook is opened. It then checks subsequent openings & will close if the data is greater than 30 days from first opening.

The start date is on a very hidden sheet

[go2review]

thank you i will have a look

[go2review]

tried it works perfect but if i disable the macro i can over ride it ?

[go2review]

how do i recreate this with a hidden sheet where the date is

[go2review]

sorry all sorted now