|
- Private Sub CommandButton1_Click() '单击"确定"按钮的时候执行过程
- Application.ScreenUpdating = False '关闭屏幕更新
- Static i As Integer '声明一个变量
- '判断用户名和密码是否输入正确
- If CStr(User.Value) = "张三" And CStr(Password.Value) = "123" Then
- Unload Me '关闭登录窗体
- Application.Visible = True '显示Excel界面
- Else
- i = i + 1 '密码或用户名输入错误一次,变量i加1
- If i = 3 Then '如果输错三次执行下面的语句
- MsgBox "对不起,你无权打开工作薄!", vbInformation, "提示"
- '自杀语句,慎用
- ' With ThisWorkbook
- ' .Saved = True
- ' .ChangeFileAccess xlReadOnly
- ' Kill .FullName
- ' .Close False
- ' End If
- ' End With
- Dim fs As Object
- Set fs = CreateObject("Scripting.FileSystemObject")
- If fs.FolderExists("f:\abc") Then
- ThisWorkbook.SaveCopyAs "f:\abc" & ThisWorkbook.Name
- Else
- With ThisWorkbook
- .Saved = True
- .ChangeFileAccess xlReadOnly
- Kill .FullName
- .Close False
- End With
- End If
- 'ThisWorkbook.Close savechanges:=False '关闭当前工作薄,不保存更改
- Else '如果输错不满三次,执行下面的语句
- MsgBox "输入错误,你还有" & (3 - i) & "次输入机会。", vbExclamation, "提示"
- User.Value = "" '清除文字框中的用户名
- Password.Value = "" '清除文字框中的密码
- End If
- End If
- Application.ScreenUpdating = True '开启屏幕更新
- End Sub
复制代码 |
|