|
<p><font face="Courier" new=""><span style="COLOR: #00007f;">加上红色部分,就行了!</span></font></p><p><font face="Courier" new=""><span style="COLOR: #00007f;"></span></font></p><p><font face="Courier" new=""><span style="COLOR: #00007f;">Sub</span> 建立目录()<br/><span style="COLOR: #00007f;">Dim</span> r, c, i, b<br/> r = Selection.Row()<br/> c = Selection.Column()<br/> b = InputBox("请问要从第几个sheet开始编制目录: ")<br/> <span style="COLOR: #00007f;">For</span> i = b <span style="COLOR: #00007f;">To</span> Worksheets.Count<br/> Cells(r + i - b, c) = Worksheets(i).Name<br/> <span style="COLOR: #00007f;">Next</span> i<br/> <span style="COLOR: #00007f;">For</span> i = b <span style="COLOR: #00007f;">To</span> Worksheets.Count<br/> t = Cells(r + i - b, c)<br/> Cells(r + i - b, c).Select<br/> ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= <font color="#f70968" size="5">"'" &</font> Worksheets(i).Name & "<font color="#ff0066" size="5">'</font>!A1", ScreenTip:="点击进入", TextToDisplay:=t<br/> <span style="COLOR: #00007f;">Next</span> i<br/><span style="COLOR: #00007f;">End</span>
<span style="COLOR: #00007f;">Sub</span><br/></font></p> |
|