Close workbook by expiration date
Posted by M. Friedman on September 06, 2001 9:41 AM
I am trying to figure using a formula or a macro, how to have a spreadsheet that will automatically close itself after a set expiration date. Think of this as a fixed date of 12/31/01 and that if the NOW() is greater than the fixed date, the workbook automatically closes itself. The idea is to create Excel "shareware" that is only good for a period of time that I specify. If there is a fancier way to do it with a set starting date and then a time lapse in days after that, that's fine also.
Any help would be greatly appreciated.