ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦b¤u§@ªí¤¤¥[¤J¶W³sµ², vba¦p¦ó¼gªk

¦b¤u§@ªí¤¤¥[¤J¶W³sµ², vba¦p¦ó¼gªk

§Ú¬Û±N¤@workbook¤¤ªº¨C¤@worksheet¦WºÙ¦C¥Ü©ó"worksheet list"¤u§@ªí¤¤,¨Ã­n¦b¨C¤@worksheet¦W¤¤¥[¤J¶W³sµ²,¥H¹F¦Ü¥i¥H«ö¤@¤U¸Óworkshet¦W«K¥i¥H¨ì¹F¸Óworksheet¤¤,½Ð°Ývba¦p¦ó¼gªk?
List Worksheet.zip (7.21 KB)

For I = 2 To Sheets.Count
     ActiveSheet.Hyperlinks.Add Anchor:=Range("a" & I), Address:="", SubAddress:= _
        Worksheets(I).Name & "!A1", TextToDisplay:=Sheets(I).Name
Next

TOP

¦^´_ 2# wang
¦hÁ«ü¾É¡C

TOP

¥¿»Ý­n¡AÁÂÁ«ü¾É±Ð¾Ç

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD