求助,excel达人请进。我的excel文件里面有几百个sheet,怎样可以创建...

发布网友发布时间：2024-10-12 05:44

共3个回答

热心网友时间：2024-11-11 22:55

建一个按钮，编写代码：

Private Sub CommandButton1_Click()
If [b1] = "" Then [b1] = "请输入表名"
If [b2] = "" Then [b2] = "请输入密码"

If [b1] = "sheet2" And [b2] = "123456" Then Sheets(2).Select
If [b1] = "sheet3" And [b2] = "223456" Then Sheets(3).Select
If [b1] = "sheet4" And [b2] = "323456" Then Sheets(4).Select
If [b1] = "sheet5" And [b2] = "423456" Then Sheets(5).Select

'...........每个表设置一个密码

[b1] = ""
[b2] = ""
End Sub

热心网友时间：2024-11-11 22:50

这样是可以做到的.我水平有限.要先建一个导航页.也就是你打开第一页就显示所有表格名.想进入那个点那个.

热心网友时间：2024-11-11 22:55

学无止境