Check computer date, before opening excel sheet.

[KSveigaard]

Hi All.

I would like to add an event in my excel sheet, that checks the computer date, if this date is passed a defined date, then the sheet will retur a text box, that the sheet is outdated and please contact...

So in short like this statements:

VBA.
In code, wirte the date that makes the sheets obsolete.
In code, write text to show in box.

Codes does:
Check computer date.
If date passed, date in code, then show box, with text also defined in code.
if not passsed, open sheet.

Hope somebody haved tried this, and have a solution.

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

[KSveigaard]

try something like this...

Please Login or Register  to view this content.

very coool - works like a charm.

[cytop]

Now please add a link to his thread to your other post for this issue - save anyone taking the time to respond to something already solved.