ªð¦^¦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 : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD