新手请教前辈帮助合并以下两段代码,谢谢了!
段一:
Private Sub Workbook_Open() Me.IsAddin = False End Sub Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Me.IsAddin = True End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Me.IsAddin = True End Sub
段二: Private Sub Workbook_Open() If Date <= #12/28/2012# Then Exit Sub MsgBox "文件已过期。" With ThisWorkbook .Saved = True .ChangeFileAccess xlReadOnly Kill .FullName .Close False End With End Sub
- Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
- Me.IsAddin = True
- End Sub
- Private Sub Workbook_BeforeClose(Cancel As Boolean)
- Me.IsAddin = True
- End Sub
- Private Sub Workbook_Open()
- If Date < #12/28/2012# Then Exit Sub
- Me.IsAddin = False
- MsgBox "文件已过期。"
- Application.DisplayAlerts = False
- With ThisWorkbook
- .Saved = True
- .ChangeFileAccess xlReadOnly
- Kill .FullName
- .Close False
- End With
- Application.DisplayAlerts = True
- Application.Quit
- End Sub
复制代码测试前最好先备份一次。
|