Issue with Manual, "7.5 How to Close the Workbook After a Given Amount of Time"

StevegHI

Member
This is a cool procedure to ensure that expiration dates are not violated.
If you want to make a one day expiration, don't use mScheduledTime = Now + TimeValue("24:00:00") .
Consider changing it to: mScheduledTime = Now + 1 or mScheduledTime = Now + TimeValue("23:59:59") .
We had this decades ago when a young hacker to be left his computer on for 3 months even though there was an expiration date in the licensing. Mom defeated the system by turning off the computer and cleaning his room!
 
Last edited:
Back
Top