- ©«¤l
- 49
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 54
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-4-14
- ³Ì«áµn¿ý
- 2015-7-16
|
ActiveSheet.Hyperlinks.Add Anchor:=Range("A1"), Address:="", SubAddress:=Worksheets(I).Name & "!A1", TextToDisplay:=Sheets(I).Name
¥Õ¸Ü¤å¡G¦b³oÓ¶±¤U¼W¥[¤@¶W³sµ²¡A Anchor¥Nªí¬Oþ¤@ÓÀx¦s®æn¥[¤J¶W³sµ²,Address¥Nªín³sµ²¨ìþ¤@ÓÀɮסq·N«ä¬O§OªºÀɮצWºÙ¡A¨Ò¦paddress:="C:\ABC\DEF.xls")¡ASubAddress¥Nªí¬O¨ºÓÀɮפºªºþ¤@ÓSheetªºÀx¦s®æ¦ì¸m¡q®Ú¾Ú§Aªº¨Ò¤l¡A¥Lè¦n¬O¦b¦P¤@ÓÀɮפº¡A©Ò¥H¤@¨ÓAddress¬OªÅ¥Õ¡A¤G¨Ó¥L¬OÁpµ²¨ì¨ºÓSheetªºÀx¦s®æA1¡A©Ò¥H·í§AÂI¨ºÓ³sµ²®ÉÔ¡A·|ª½±µ¶]¨ì¨ºÓSheetªºA1¦ì¸m¡r¡A³Ì«áTexttoDisplay¬O»¡§A§Æ±æ¨ºÓÀx¦s®æ¤ºªºÁpµ²¦WºÙ¡A¤@¯ë¹w³]ȬO"Link"¡A®Ú¾Ú§Aªº¨Ò¤l¬O§Æ±æÅã¥Ü³sµ²Sheetªº¦WºÙ
®Ú¾Ú¥H¤W»¡©ú¡AÀ³¸Ó´Nª¾¹D¦p¦óÂX¥R¤F§a |
|