|
本帖最后由 laynet 于 2019-9-6 22:37 编辑
密码本1.rar
(11.66 KB, 下载次数: 61)
随便写写,还有很多漏洞,得你自己补上,密码不能写在工作表内,得写在宏里面,然后给宏加上密码.
- Sub 输入密码()
- Dim P(), S()
- ReDim P(1 To 100)
- ReDim S(1 To 100)
- P(1) = "1" '密码1
- P(2) = "2" '密码2
- P(3) = "3" '密码3
- P(4) = "4" '密码4
- S(1) = "Sheet1" '密码1对应的表
- S(2) = "Sheet2" '密码2对应的表
- S(3) = "Sheet3" '密码3对应的表
- S(4) = "Sheet4" '密码4对应的表
- mm = 1
- m = InputBox("请输入密码查看内容", "提示")
-
- For i = 1 To 100
- On Error Resume Next
- Sheets(S(i)).Visible = xlVeryHidden '-1显示,xlVeryHidden隐藏
- If m = P(i) Then
- On Error Resume Next
- Sheets(S(i)).Visible = -1 '-1显示,xlVeryHidden隐藏
- Sheets(S(i)).Select
- mm = 0
- End If
- Next i
-
-
- If mm = 1 Then MsgBox "你确定你有查看权限?", vbOKOnly
-
-
-
-
-
-
-
-
- End Sub
复制代码
|
评分
-
2
查看全部评分
-
|