|
本帖最后由 不解木野狐 于 2012-2-7 00:09 编辑
- Option Explicit
- Sub 创建目录()
-
- Application.ScreenUpdating = False
- Dim i As Integer, Sht_Count
- If Not IsSht("目录") Then Sheets.Add(Sheets(1)).Name = "目录"
- Sht_Count = Sheets.Count
- For i = 2 To Sht_Count
- Sheets("目录").Hyperlinks.Add Anchor:=Sheets("目录").Cells(i - 1, 2), Address:="", SubAddress:="'" _
- & Sheets(i).Name & "'!A1", TextToDisplay:=Sheets(i).Name, _
- ScreenTip:="单击打开:" & Sheets(i).Name
- Next i
- Application.ScreenUpdating = True
- Dim SHE As Worksheet
- For Each SHE In Sheets
- If SHE.Name <> "目录" Then
- SHE.Select
- ActiveWindow.SelectedSheets.Visible = False
- End If
- Next
- Application.OnKey "^j", "返回目录"
- End Sub
- Function IsSht(ShtName As String) As Boolean
- On Error Resume Next
- Dim sht As Worksheet
- Set sht = Sheets(ShtName)
- IsSht = (Err = 0)
- End Function
- Sub 返回目录()
- ActiveSheet.Select
- ActiveWindow.SelectedSheets.Visible = False
- If IsSht("目录") Then Sheets("目录").Select
- End Sub
-
复制代码
|
|