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

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

ÁôÂæ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

¦^´_ 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

        ÀR«ä¦Û¦b : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD