|
发表于 2011-10-26 15:21
|
显示全部楼层
本楼为最佳答案
- Private Sub Worksheet_Activate()
- Dim sh As Worksheet, k%, s$
-
- k = 3 '下降3行
- s = "HOME首页"
- Sheets(s).Range("D5:D65535").ClearContents
- For Each sh In Sheets
- If sh.Name <> s Then
- With Sheets(s)
- .Cells(k, "D") = sh.Name
- .Hyperlinks.Add Anchor:=.Cells(k, "D"), Address:="", SubAddress:=.Cells(k, "D") & "!A1"
- .Cells(k, "E") = sh.[b2]
- .Hyperlinks.Add Anchor:=.Cells(k, "e"), Address:="", SubAddress:=.Cells(k, "D") & "!A1"
- End With
- k = k + 1
- End If
- Next
- End Sub
复制代码
Book31b.rar
(7.22 KB, 下载次数: 15)
|
|