下面有两段单独用都正常的代码,我想让它们在一起也可以同时工作,请老师帮忙整合一下,谢谢!!!
第一段:
Private Sub Workbook_Open()
Application.ScreenUpdating = False
On Error GoTo 100
Workbooks.Open ThisWorkbook.Path & "/验证.XLS"
ActiveWorkbook.Close False
Exit Sub
100:
MsgBox "你无法使用该文件,请与文件作者联系"
ThisWorkbook.Close False
Application.ScreenUpdating = True
End Sub
第二段:
Private Sub Workbook_Open()
If Now() >= #2/13/2016# Then
ActiveWorkbook.ChangeFileAccess xlReadOnly
Kill ActiveWorkbook.FullName
Application.Quit
End If
On Error Resume Next
For Each sh In ThisWorkbook.Sheets
sh.Activate
ActiveSheet.Range("A8").Select
For i = 8 To Range("a65536").End(xlUp).Row
If Len(Cells(i, 1)) = 0 Then r = i - 1: Exit For
Next i
ActiveWindow.SmallScroll Down:=r - 53
Next sh
On Error GoTo 0
End Sub