Time limited to open exel file

[Peterko]

HI,

I have one excel file which I plan to send to other person. But I need this file to be openable/valid by this person just 20 days after first opening of the file.
After 20 days this person will not be able to open the file any more.

Any suggest, please?
Thanks in advance.

Peters

 

[Peterko]

Yes, now its works. I can see the date in A1 cell. I have just try change the date, whether it will not show document, just information: "This Book Is Expired"..., will see.

Thanks

L.

I suppose, something should be in A1 cell, but nothing displayed?

when you first save the filie, A1 should be EMPTY.

so that when it is first opened by your intened user, the code will put the date in that cell.

future times it is opened, it will not CHANGE the date in A1. But will evaluate if todays' date is = or greater than that date.