- ©«¤l
- 2833
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2889
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-12
|
ThisWorkbook.Worksheets("¤u§@ªí2").Visible = False
¦b¤u§@ªí¨Æ¥ó°Ï, ¥i¥H³o¼Ë¼g
Me.Visible = False
================================
¥t¥~, ±N"¤u§@ªí2"¤Î"¤u§@ªí3"ªº¦Û°ÊÁôÂõ{¦¡½X§R°£, ¨Ã±N¨ä³]¬°¥i¨£,
±N¤u§@ªí1ªº¶W³sµ²¨Æ¥ó§ï¬°¦p¤U:
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Sheet_Name = ActiveCell.Value
MsgBox Sheet_Name
End Sub
°õ¦æ"¶W³sµ²", ·|µo²{Sheet_Name¬O"¤u§@ªí1", ¦Ó¤£¬O¨ä¥¦,
ªí¥Ü³oÓActiveCell, ¬O³Q³sµ²¤u§@ªíÀx¦s®æªº¤º®e, ¦Ó¤£¬O¤u§@ªí1ªºa1¤º®e~~
==================================
±N¤u§@ªí2ªºA1¤º®e, §ï¦¨"¤u§@ªí15", ¦A¥Î§Aì¨ÓÀɮתºµ{¦¡½X¸Õ¸Õ,
ÂI²Ä¤@¦¸¶W³sµ², ¤u§@ªí2Åã¥Ü¬°¥i¨£, ¦ýµe±ÁÙ¬O¯d¦b¤u§@ªí1,
¦AÂI¤@¦¸¶W³sµ², ·|¶]¨ì¤u§@ªí2, ¦ýµ{¦¡½X·|¸õ¥X¿ù»~, ¦]¬°"¤u§@ªí15"¨Ã¤£¦s¦b~
======================= |
|