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

[µo°Ý] ¦Û­qªí³æ¹ï©óVisual Basic for Applications¶}±Òªº¼vÅT

[µo°Ý] ¦Û­qªí³æ¹ï©óVisual Basic for Applications¶}±Òªº¼vÅT

¥»©«³Ì«á¥Ñ av8d ©ó 2021-10-2 16:32 ½s¿è

(¤§«e°ÝÃD¦Û¦æ¸Ñ¶}¤F¡A±µÄòµo°Ý)
­ì¨Ï¥ÎApplication.VBE.MainWindow.Visible = True
Åý¶}ÀÉ«á¡A¦Û°Ê¶}±ÒVBA¡A¦pªþ¥ó
¥i¥Î.jpg
2021-10-2 16:29


¦ý¦b·s¼W¦Û­qªí³æ«á¡A°¨¤WÅܦ¨¦Ç¦â¡A
°õ¦æ«á¡AµLªkÅý·Q­n¶}±Òªºµøµ¡¦b²´«e¡A
·|¥d¦í¨Ã°{Ã{
¥¢®Ä.jpg
2021-10-2 16:31


ExcelÀɦp¤U
20211002 µo°Ý.rar (19.96 KB)

¨D±Ï¦U¦ì«e½ú­Ì¡A·P¿E¤£ºÉ¡C

¦^´_ 1# av8d


    §ä¨ì¤èªk¤F¡A·s¼W¤@¦ê
  1. ThisWorkbook.VBProject.VBComponents("Module1").Activate
½Æ»s¥N½X
«e´£°O±o¥ý·s¼W¤@­ÓModule

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD