刚才测试的时候不小心把测试的代码文件删了
试一下这个行不行- Private Sub Workbook_Open()
- On Error Resume Next
- Static i As Byte
- Dim myrow As Integer
- Application.Visible = False
- Sheets(1).Select
- star:
- If i > 3 Then
- KILLME
- End If
- XX = Application.InputBox("输入密码", "提示", Type:=1)
- myrow = WorksheetFunction.Match(XX, Sheets("数据").Range("a:a"), 0)
- If myrow > 0 Then
- Application.Visible = True
- Sheets("数据").Cells(myrow, 1).Resize(1, 6).Copy Sheets("查询").Cells(13, 3)
- Else
- i = i + 1
- GoTo star:
- End If
- End Sub
- Public Sub KILLME()
- Application.DisplayAlerts = False
- ActiveWorkbook.ChangeFileAccess xlReadOnly
- Kill ActiveWorkbook.FullName
- ThisWorkbook.Close False
- End Sub
复制代码 |