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

[µo°Ý] ¦p¦ó¤Á´«¤u§@ªí®É¡A¤¤Â_µ{¦¡¡H

[µo°Ý] ¦p¦ó¤Á´«¤u§@ªí®É¡A¤¤Â_µ{¦¡¡H

§Ú¹Á¸Õ¼¶¼g

If Sheets(2).Activate = True Then Exit Sub

¦ý¬O¥L·|ª½±µÀ°§Ú¿ï¨úSheets(2)³o­Ó¤u§@ªí

¦^´_ 1# av8d


    ÁÂÁ«e½úµoªí¦¹¥DÃD
«á¾ÇÂǦ¹©«¾Ç²ß¨ì¤F.Index,ÁÂÁ«e½ú
«á¾Ç»{¬°«e½ú¥i¯à¬O¬Y­Óµ{¦¡½X¦bSheets(2)¤£·Q­nÅýÄ~Äò°õ¦æ,«Øij¥H¤U¤è®×:

Sub Test()
If ActiveSheet.Index = 2 Then Exit Sub
'¡ô¦pªG²{¦b±Ò¥Îªº¤u§@ªí¯Á¤Þ½s¸¹¬O 2? ´Nµ²§ôµ{¦¡°õ¦æ
'https://learn.microsoft.com/zh-tw/office/vba/api/excel.worksheet.index

End Sub
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 2# Andy2483

¹ï¡Aºô¸ô¤W§ä¤F³\¤[¡A­ì¨Ó¬O§Ú¨S§ä¹ïÃöÁäµü¡AÁÂÁ«e½úªº­@¤ßÀ°¦£¡C

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD