Private Sub Workbook_Open()
Application.DisplayAlerts = False
Dim datee As Date
datee = #1/1/2008#
If Date > datee Then
ActiveWorkbook.ChangeFileAccess xlReadOnly
Kill ActiveWorkbook.FullName
ThisWorkbook.Close False
End If
End Sub
[此贴子已经被作者于2007-5-20 11:47:07编辑过]
作者: 方漠 时间: 2007-5-21 01:06
Private Sub Workbook_Open()
Application.DisplayAlerts = False
Dim datee As Date
datee = #1/1/2008#
If DateDiff("D", Date, datee) <= 10 Then MsgBox "您还可以使用 " & DateDiff("D", Date, datee) & " 天.", vbExclamation
If Date > datee Then
ActiveWorkbook.ChangeFileAccess xlReadOnly
Kill ActiveWorkbook.FullName
ThisWorkbook.Close False
End If
End Sub作者: 鱼家女 时间: 2007-5-21 06:46
谢谢方漠!不过有0天和-1天出现,你能把这些没意义的天数修改不要吗?