¦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
- 559
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 626
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-6-14
|
¥»©«³Ì«á¥Ñ hugh0620 ©ó 2012-3-22 13:34 ½s¿è
¦^´_ 1# c_c_lai
¤U¹Ï¬O§A·Qnªºµ²ªG~
³]¨âÓªí³æ«ö¶s
[«ö¶s 1]=>open
[«ö¶s 2]=>close
³]¨âÓµ{¦¡½X¦bsheet1¤¤- Sub ex1() 'Close=false Open=True
- [«ö¶s 1].Visible = True
- [«ö¶s 2].Visible = False
- End Sub
- Sub ex2() 'Open=false Close=True
- [«ö¶s 2].Visible = True
- [«ö¶s 1].Visible = False
- End Sub
½Æ»s¥N½X ³]¤@Óµ{¦¡½X¦bthisworkbook¤¤- Private Sub Workbook_Open()
- [«ö¶s 1].Visible = False
- End Sub
½Æ»s¥N½X [«ö¶s 2]«ü©w¥¨¶°Sheet1.ex1
[«ö¶s 1]«ü©w¥¨¶°Sheet1.ex2
ªí³æ«ö¶sªº³]©w.rar (6.79 KB)
|
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|
- ©«¤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 |
|
|
|
|
|
|