ªð¦^¦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

¦^´_ 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
BOOK1.jpg
2012-3-12 10:25
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 : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD