¦p¦ó±oª¾«ö¶s(ªí³æ±±¨î¶µ)ªºObject Name¤Î±±¨î
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦p¦ó±oª¾«ö¶s(ªí³æ±±¨î¶µ)ªºObject Name¤Î±±¨î
½Ð±Ð±z¡G
§Ú¨Ï¥Î¤F ¶}µo¤Hû->´¡¤J->«ö¶s(ªí³æ±±¨î¶µ) ¡A ¤@Ó¦W¬°¶}±Ò¶s¡A¥t¤@Ó¬°Ãö³¬¶s¡C
½Ð±Ð±z¡A·í§Ú·Qn¦b EXCEL ¶}±Ò®É¡A¶}±Ò¶s¬°ÁôÂÃ(Hide)¼Ò¦¡¡A·í§Ú¿ï«öÃö³¬¶s®É¡A
¶}±Ò¶s´NÅã¥Ü¥X¨Ó(Enable)¡AÃö³¬¶s´N¦P®ÉÅܧó¬°ÁôÂÃ(Hide)¼Ò¦¡¡A¤Ï¤§¥çµM¡C
¦]¬°§Ú¦bVBA½s¿è¾¹¤º¡A¤£ª¾n¦p¦ó±oª¾³o¨Ç«ö¶sªºObject Name¡A¥H¤Î¯à§_¨Ï¥Î
Enable©ÎDisable»yªk¡A³Ó¦ÜÁÙ·Q±N'¶}±Ò'¦r¥y§ï¬°¨ä¥L¦r»y©ÎÅܧóÃC¦âµ¥µ¥¡A
¦b¦¹ÁÂÁ±z¤F¡I |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
ÁÂÁª©¥D«ü¾É¡A¤£¹L¦b¦sÀɮɡA«o¥X²{¤F¥H¤U¤§°T®§¡G
YnÀx¦s¨ã¦³³o¨Ç¥\¯àªºÀɮסA½Ð«ö¤@¤U§_¡A¦b©óÀÉ®×Ãþ«¬²M³æ¿ï¾Ü±Ò¥Î»E¶°ªºÀÉ®×Ãþ«¬¡C
YnÄ~ÄòÀx¦s¬°µL¥¨¶°¬¡¶Ã¯¡A½Ð«ö¤@¤U¬O¡C
¦pªG¿ï¬O¡A¦sÀÉ«á¦A¦¸¶}±Ò¡AVBA³£¤£¨£¤F¡A¿ï§_¥ç¤£¬O¡A½Ð±ÐÀ³¦p¦ó¥¿½T«Ø¸m¡H |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
«D±`·PÁª©¥Dªº«ü¥¿¡A¥H©¹²ßºD¦s¦¨.xlsªºÀɮ׫¬ºA©Ò¥H¨S¦³¯d·N¨ì2010ª©ªº.xlsx©M.xlsm«¬ºAÀ³¥Îªº®t²§©Ê¡A½T¹ê¨ü±Ð¤F¡A¦hÁ±z¡I
¤µ°²³]¦pªG¤£¬O¨Ï¥Î
¤u§@ªí1.Shapes(Application.Caller).Visible = False ©ÎªÌ¬O [«ö¶s 1].Visible = False ¤è¦¡¨Ó³B²z¡A¦Ó¬OÀ³¥Î «ö¶sªº¦r«¬§ïÅÜÃC¦â ©Î «ö¶sªº¥~Æ[ªº§Îª¬¤§¥W¥Y¨Óªí¥Üªº¸Ü¡A¨º¤£ª¾¸Ó¦p¦ó¼¶¼g¡H
¦h¦¸¥´ÂZ±z¯u¤£¦n·N«ä¡I ¦A¦¸»¡Án·PÁ±z¡I |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¥Ø«e§Úªºªí³æ¬O¥Î[«ö¶s 1].Visible = False ¤è¦¡¨Ó³B²z¡A¦]¬°¥Î ¤u§@ªí1.Shapes(Application.Caller ) .Visible = False ªº¤è¦¡±a¤Jµ{¦¡¸Ì¥X²{§ä¤£¨ì OC ªº¥¨¶°ªº°T®§¡A¦h¦¸¥´ÂZ¦A¦¸»¡Án·PÁ±z¡I |
|
|
|
|
|
|