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

ÁôÂéάOÂê©w¦WºÙºÞ²z­û

ÁôÂéάOÂê©w¦WºÙºÞ²z­û

¤w¸g©w¸q¦n¦WºÙºÞ²z­û,¬°¨¾¤î¨Ï¥ÎªÌ­×§ï¦WºÙ©w¸qªº½d³ò,½Ð°Ý¦WºÙºÞ²z­ûªº©w¸q¯à°÷ÁôÂéάOÂê©w¤£¯à­×§ï¶Ü?

BOOK1.jpg (66.93 KB)

BOOK1.jpg

¦^´_ 1# VANESSA

«OÅ@¤u§@ªí
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤F¸Ñ¤F,ÁÂÁÂ

TOP

ÁôÂæWºÙ

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-3-9 21:40 ½s¿è

Sub HideName()
Dim nName As Name
For Each nName In Names
     nName.Visible = False 'TRUE ´N¬OÅã¥Ü
Next nName
End Sub

sub HideName1()

ActiveWorkbook.Names("nName").Visible = False

end sub

³q±`·|»s¦¨©w¸q¦WºÙºÞ²z¤u¨ã

TOP

§Ú¤w¸g±N³o­Óµ{¦¡copy¨ìexcel¶}µo¤H­ûªºÀ˵øµ{¦¡½X,¦ý¬O¨S¦³Åã¥Ü¥X
¨º­Óªí(©w¸qÁôÂó]©w),§Ú¤£ª¾¹D­þ¸Ì°µ¿ù¤F Book3(2).zip (9.83 KB)

TOP

¥i¥H½Ð°Ý³o­Ó"©w¸q¦WºÙºÞ²z¤u¨ã"ªº¥Ø¿ý¬O«ç»ò²£¥Íªº¶Ü?

TOP

¦^´_ 5# VANESSA

½Ð±Nµ{¦¡©ñ¨ì¼Ò²Õ¤¤¦Ó¤£¬OSHEET1¤¤    Book3.rar (9.12 KB)

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-3-14 00:06 ½s¿è
¥i¥H½Ð°Ý³o­Ó"©w¸q¦WºÙºÞ²z¤u¨ã"ªº¥Ø¿ý¬O«ç»ò²£¥Íªº¶Ü?
VANESSA µoªí©ó 2012-3-13 15:28


¶·¨Ï¥ÎVBA¦Û»s«OÅ@«O±K¤u¨ã
http://forum.twbts.com/thread-51-1-1.html

TOP

¤F¸Ñ¤F,­ì¨Ó¬O©ñ¨ì¼Ò²Õ¤¤¦Ó¤£¬OSHEET1¤¤,·PÁÂ

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD