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

[­ì³Ð] µøµ¡Àx¦sºî¦XÀ³¥Î«OÅ@«O±K§Þ¥©

[­ì³Ð] µøµ¡Àx¦sºî¦XÀ³¥Î«OÅ@«O±K§Þ¥©

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2010-11-28 12:57 ½s¿è

¼g³o½g§Ú¥i¯à­n¼g¦n¤[
­n±q¥|­Óºc­±¨Ó¬Ý
¸£¤l­n¤À¦¨¥|«×ªÅ¶¡¨Ó«ä¦Ò

¦³¿³½ìªº¤H¶·¥ý¾Ç·|¤U¦C¦U©«
¥¼¾Ç·|½Ð¤Å¶i§Ú©È±z¸£¤l¥´µ²

[­ì³Ð] ÁôÂÃÄæ¦C¤]¬O¤@ªù§Þ¥©¡@¨S¾Ç·|­n³Z§O»¡·|ÁôÂüÚ(³q«h)
[­ì³Ð] ªü¦NExcel ¥¼¤½¶}ªºÁôÂÃÄæ¦C§Þ¥© ±j¤O²Ä¤@¼u
[­ì³Ð] ªü¦NExcel ¥¼¤½¶}ªºÁôÂÃÄæ¦C§Þ¥© ±j¤O²Ä¤G¼u
[­ì³Ð] ªü¦NExcel ¥¼¤½¶}ªºÁôÂÃÄæ¦C§Þ¥© ±j¤O²Ä¤T¼u
[­ì³Ð] ¦p¦ó«OÅ@¸ê®Æ¤£¥i¼W¥[Äæ¦C§Þ¥©1ª«¥óªk
[­ì³Ð] ¦p¦ó«OÅ@¸ê®Æ¤£¥i¼W¥[Äæ¦C§Þ¥©2...
[¤À¨É] ¦p¦ó«OÅ@Àx¦s®æ¸ê®Æ§Þ¥©1°}¦C¤½¦¡(¦¹ªk¤]¥i¥H¥Î¨Ó«OÅ@°Ï°ìÄæ¦C¤£³Q§R°£)
[­ì³Ð] ¯S®í­áµ²µ¡®æ­­¨îµøµ¡¬¡°Ê»P¥i¨£½d³ò
[­ì³Ð] ¯S®í¤À³Îµøµ¡«O±KÁôÂÃÀx¦s®æ
[­ì³Ð] ¦p¦ó¦bEXCEL¤¤¤@Ãä¥þÄý¤½¦¡¡A ¤@Ãä¥þÄý­pºâµ²ªG


­nµ¥§Ú¦³ªÅ¾ã²z...¥ý©ñ¤@¤U

¥u¥Î¨ì³æ¤@ºc­±À³¥Î¡A¤£©ñ¨ì²Ä¤@¥D½g´T

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-12-26 23:07 ½s¿è

ªñ¤é¬Ý¨ì³o½g°ÝÃD¤º®e¦p¤U¦C³sµ²

µoªí©ó 2010-12-26 22:40 | ¥u¬Ý¸Ó§@ªÌ ¦^´_ 26# 317
¥¿¦]¬°¦p¦¹¡A·íªìÅý§Úı±o«Ü¬¯ªº«OÅ@±K§Þ¡A´N¨S¦A²`¤J¬ã¨s¡C
¦]¬°¼h¼hªº±K½X«OÅ@¤Î²`«×ÁôÂáA¥u·|³y¦¨¦Û¤wºûÅ@¸ê®Æªº¤£«K¡C
«á¨Ó¡A§ÚÁÙ¬O±Ä¥Î³Ì²³æªº¤èªk...
´N¬O§â¥i¥H¤À¨ÉªºÄæ¦ì¶×¨ì¥t¤@­Ó¬¡­¶Ã¯XD
http://forum.twbts.com/viewthread.php?tid=2116&extra=pageD1&page=3
__________________________________________________________________
­ì·Q¦^´_¦³§ó¦nªº¤èªk¡A¥i¥H°w¹ï¨Ï¥ÎªÌ°µ¤ÀÃþÅã¥ÜÁôÂÃSHEET¨Ã²¤Æ»PÁYµuVBAªº¼¶¼g¡A
¦ýê©ó³o½g«OÅ@«O±K©«¤@ª½¨S®É¶¡§¹¦¨¡A¦¹½gÀ³¥Î³¡¥÷µe­±¼h¼h¤¬¬Û¥æÅ|¡A
­Y³£­n§ì¨Ó¹B¥Îµ¹§e²{µ¹¤j®aµøµ¡µe­±µ¥¸û¬°½ÆÂø¡A­n¼g»P·Q½d¨Ò¡C
«áÄò¤S¥X²{¡A·íªìÅý§Úı±o«Ü¬¯ªº«OÅ@±K§Þ¡A´N¨S¦A²`¤J¬ã¨s¡A²`«×ÁôÂ÷|³y¦¨¦Û¤wºûÅ@¸ê®Æªº¤£«Kµ¥µ¥¡A
»¡¯uªº§Úı±o¡A¦b©óÆ[©À°ÝÃD¡A¶X³o¦¸¼g­ÓÀ³¥Î½d¨Ò¡A¦ý¹ï©ó³o¤@«h¤å³¹¥uÀ³¥Î¨ì1/4ªº¥\¯à

§ÚÁ|¤@­Ó¨Ò¤l
µµ·L¤æ¼Æ³]­p»PºûÅ@
1.Àɮ׳]­p¼Ò¦¡
2.Àɮק¹¦¨¼Ò¦¡
¥H«e³£­n«Üªøªºµ{¦¡®i¶}»PÁôÂáA¬Ý¬ÝªþÀÉ ´N·|ÁA¸Ñ¡Aµ{¦¡¦³¤ñ¸ûºC¡A¦ý¥u¨Ï¥Î¼Ð·Çµ{¦¡

´N¤£¦h»¡ ­«ÂI¦b"¤U¹Ï¨â­Ó«ö¶s"»P"¦Û­qÀ˵ø¼Òµø"µ{¦¡¦p¤U
Sub Macrods()
ActiveWorkbook.CustomViews("³]­p¼Ò¦¡").Show
End Sub

Sub Macroed()
ActiveWorkbook.CustomViews("§¹¦¨¼Ò¦¡").Show
End Sub

2011-01-04 21-37-21.jpg
abbr_383e95aaf85a6524d67515c6266649af.rar (390.79 KB)

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-12-26 23:10 ½s¿è

¥Ñ©ó¼È®É¨S§¹¾ãªº¨Ò¤l¼¶¼g§¹¦¹½g
±Nµøµ¡Àô¹Ò¶i¶¥¥Îªk¥|ºc­±­nÂI¸m©ñ©ó¦¹(­«ÂI¦b©ó§Þ¥©¥i¥H¥Ñ¤º¦Ó¥~¡A­Ý¥BÀx¦s©Ê»PµLÀx¦s©Ê·|¦³¥æ¤¬§@¥Î)
http://forum.twbts.com/viewthread.php?tid=8678&extra=

TOP

ÁÂÁª©¤jªº¤À¨É~¤U¸ü¾Ç²ß¤@¤U,ÁÂÁ±z~

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD