Any idea how to make an Excel spreadsheet 'expire' after a certain date?

[lrowlandson]

Hey there! I'm wondering if anyone knows how to make a spreadsheet expire after a certain date? I thought this would be a great security feature for an annual subscription feature I have on my site. Ideally the spreadsheet would lock or a password would be required after a certain date - something like that.


Any ideas?


PS - loving this site - amazing!

 

[kchiba]

Hi


In VBA you could check the date on open and then set a password.


The problem is that the user must have set Excel set to Enable Macros, if this is not the case the file would open without the macro running