網(wǎng)站制作NEWS
SCROLL
求助，excel達(dá)人請(qǐng)進(jìn)。我的excel文件里面有幾百個(gè)sheet,怎樣可以創(chuàng)建一個(gè)搜索目錄搜索并跳轉(zhuǎn)到相關(guān)的頁面
建一個(gè)按鈕，編寫代碼：
Private Sub CommandButton1_Click()
If [b1] = "" Then [b1] = "請(qǐng)輸入表名"
If [b2] = "" Then [b2] = "請(qǐng)輸入密碼"
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
'...........每個(gè)表設(shè)置一個(gè)密碼
[b1] = ""
[b2] = ""
End Sub
多重隨機(jī)標(biāo)簽