|
发表于 2015-2-22 14:47
|
显示全部楼层
本楼为最佳答案
- Private Sub CmdOk_Click() '单击"确定"按钮的时候执行过程
- Dim sht As Worksheet
- Application.ScreenUpdating = False '关闭屏幕更新
- Static i As Integer '声明一个变量
- '判断用户名和密码是否输入正确
- If CStr(User.Value) = "ABC" And CStr(Password.Value) = "123" Then
- Unload Me '关闭登录窗体
- Application.Visible = True '显示Excel界面
- ElseIf CStr(User.Value) = "ZC" And CStr(Password.Value) = "321" Then
- '显示Excel界面
- Worksheets("支出").Visible = xlSheetVisible
- For Each sht In Worksheets
- If sht.Name <> "支出" Then sht.Visible = xlSheetVeryHidden
- Next
- Unload Me '关闭登录窗体
- Application.Visible = True '显示Excel界面
- ElseIf CStr(User.Value) = "QB" And CStr(Password.Value) = "789" Then
- For Each sht In Worksheets
- sht.Visible = xlSheetVisible
- Next
- Sheet1.Visible = xlSheetVeryHidden
- Unload Me '关闭登录窗体
- Application.Visible = True
- Else
- i = i + 1 '密码或用户名输入错误一次,变量i加1
- If i = 3 Then '如果输错三次执行下面的语句
- MsgBox "对不起,你无权打开工作薄!", vbInformation, "提示"
- ThisWorkbook.Close savechanges:=False '关闭当前工作薄,不保存更改
- Else '如果输错不满三次,执行下面的语句
- MsgBox "输入错误,你还有" & (3 - i) & "次输入机会。", vbExclamation, "提示"
- User.Value = "" '清除文字框中的用户名
- Password.Value = "" '清除文字框中的密码
- End If
- End If
- Application.ScreenUpdating = True '开启屏幕更新
- End Sub
复制代码 |
|