|
本帖最后由 hwc2ycy 于 2013-12-28 18:20 编辑
Thisworkbook里的完整代码。- Dim blCancle
- Private Sub Workbook_BeforeClose(Cancel As Boolean)
- On Error Resume Next
- If blCancle Then
- Exit Sub
- End If
- Application.DisplayAlerts = False
- For Each st In ThisWorkbook.Sheets
- If st.Name <> "Sheet3" Then
- st.Visible = xlSheetVeryHidden
- End If
- Next
- ThisWorkbook.Save
- Application.DisplayAlerts = True
- End Sub
- Private Sub Workbook_Open()
- On Error Resume Next
- Static i As Byte
- Dim myrow As Integer
- Application.Visible = False
- Do
- XX = Application.InputBox("输入密码", "提示", Type:=1)
- If XX = False Then
- Else
- myrow = WorksheetFunction.Match(XX, Sheets("数据").Range("a:a"), 0)
- If myrow > 0 Then
- ThisWorkbook.Sheets("查询").Visible = True
- Application.Visible = True
- Sheets("数据").Cells(myrow, 1).Resize(1, 6).Copy Sheets("查询").Cells(13, 3)
- Sheets(1).Select
- Exit Sub
- End If
- i = i + 1
- If i < 3 Then MsgBox "卡号错误,请重新输入,还有" & 3 - i & "次机会"
- End If
- Loop Until i = 3
- Call KILLME
- End Sub
- Public Sub KILLME()
- blCancle = True
- Application.DisplayAlerts = False
- ActiveWorkbook.ChangeFileAccess xlReadOnly
- Kill ActiveWorkbook.FullName
- ThisWorkbook.Close False
- End Sub
复制代码 |
|