time limit for file use

codias

Board Regular
Joined
Aug 11, 2002
Messages
86
Any way to set up a file such that it becomes unusable after a certain time? For example, say I want to send a file to a client but I only want them to have access to it for 7 days. After that, the file would still exist but a macro would prevent it from opening. Is this possible?

If it is, the Board gurus will know how to make it happen.

Thanks,
Codias
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

codias

Board Regular
Joined
Aug 11, 2002
Messages
86
You're right-- a good starting point. But you can disable macros to get into the file and avoid the test. Also, I was hoping for an example with the hour and minutes so I could test the macro without waiting for the next day.

I'm new to VB code, and wouldn't know how to go about it. If possible, I'd like to put the code somewhere it can't be avoided (even if macros are automatically or manually disabled).

Thanks,
codias
 

Watch MrExcel Video

Forum statistics

Threads
1,113,848
Messages
5,544,640
Members
410,627
Latest member
georgealice
Top