Time Limit
Time Limit
(OP)
How can you impose a time limit on a spreadsheet as you see with some shareware programs that have a 30 day limit?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Time Limit
Sub limit()
Dim LimDate
If not LimDate Then LimDate = Date +30
End Sub
dunno if it works but it may be some basis for your idea
Cyril Guichard
Mechanical Engineer
RE: Time Limit
Cyril Guichard
Mechanical Engineer
RE: Time Limit
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: Time Limit
Sub Auto_Open()
If Date < #10/31/2003# Then Exit Sub
With ThisWorkbook
.Saved = True
.ChangeFileAccess xlReadOnly
Kill .FullName
.Close False
End With
End Sub