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

[­ì³Ð] ¥Î¨ä¥L¤èªk«OÅ@¤u§@ªí

¦^´_ 10# lin


¦pªG­n±o¨ìµ{¦¡½X¥Î¿ý»s§Y¥i
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

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

´I­ô¥L­nªº§Þ¥©¡A¬O¤@­Ó¤ñ¸û¯S§Oªº¡A¥Ø«e¥u¦³§Ú¦b¥Îªº¤p¤èªk
¥Ø«e¬Ý¨Ó¥u³Q¥Lµo²{

±z¥i¥H¬Ý¨ìªü¦N«e¤@¼Ó©Ò©ñªºªþ¥óXLSÀɮסA¸Ì­±¬O¦³3­ÓSHEET¡A¦ýªì©lÅã¥Ü¥u¦³¤@­Ó ©Î«ü©wªº´X­Ó¤u§@ªí
¤£¬OÁôÂäu§@ªíªº¤è¦¡¡A¦U¦ì¥i¥H¤U¸ü¬Ý¤@¤U´Nª¾¹D

³o­Ó§Þ¥©ªº¥\¯à:¤£³z¹L¤u§@ªíÁôÂà ¨ÓÁôÂäu§@ªí
¥L¦³µo²{ªí¥Ü¥L«Ü¥Î¤ß¡A§Ú¤]«Ü¼Ö·N±Ð¾Ç³o­Ó§Þ¥©


¥ý¦^µª
¤u§@ªí¼ÐÅÒÁôÂÃ(ªí®æ¥ª¤U¤è¥k©Ô§Y¥i¥X²{¤u§@ªí-ÁôÂÃÄæ¦C®É±`¥Î·f°t¤p§Þ¥©)
­º¥ý³o¬O­Ó©Ç§Þ¥©...¤]¬O¤H­Ì·|©¿²¤ªº³¡¤À
»¡¯}¤£­È¿ú
§@ªk½Ð¬Ý¤U¹Ï°Êµe:
°µ¨ì³Ì«áÂI2¤U¤ô¥­¨÷¶b¥L·|ÁY¦^¥h
§@§¹¦sÀÉ´N¦n
A.gif

TOP

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

¦^´_ 10# lin

³o¤]¬O¤@­Ó¤ñ¸û¯S§Oªº¡A¬Ý¤F³o»ò¦h§@«~¤]¬O¥Ø«e¥u¦³§Ú¦b¥Îªº¤p¤èªk
§A¦³µo²{ªí¥Ü«Ü¥Î¤ß¡A§Ú¤]«Ü¼Ö·N±Ð¾Ç³o­Ó§Þ¥©

¥ý¦^µª
¦p¦ó²£¥Í¤u§@ªí¼ÐÅÒ±²¶bÁôÂÃ?
³o­Ó§Þ¥©ªº¥\¯à:¨Ï¥Î¤ô¥­±²¶b¨ÓÁôÂäu§@ªí¼ÐÅÒÅý¤H´Nºâ¶}Ãö¤u§@ªí¼ÐÅҿﶵ¡A¤]¬Ý¤£¨ì¤u§@ªí¼ÐÅÒ

­º¥ý³o¬O­Ó©Ç§Þ¥©...¤]¬O¤H­Ì·|©¿²¤ªº³¡¤À
»¡¯}¤£­È¿ú
§@ªk½Ð¬Ý¤U¹Ï°Êµe:
§@§¹¦sÀÉ´N¦n
ASD.gif

§A¯uªº¬O¨Ó«õÄ_ªº¼Ú
¤@¨Ó´N¤w¸g«õ¤F§Ú2­Ó¨SÁ¿¸Ñ¹Lªº§Þ¥©
³o¨â­Ó¤p§Þ¥©©ñ³o»ò¤[³£¨S¤Hµo²{...¥u¦³§Aµo²{
½ÐÄ~Äò¥[ªo

TOP

¦^´_ 12# HUNGCHILIN

¦^´_  lin
GBKEE µoªí©ó 2012/12/14 14:16    '©Î¬O        ActiveWindow.TabRatio = 0
1

µû¤À¤H¼Æ

TOP

ªü¦N¥S:
¤£¦n·N«ä¡A¤S­n³Â·Ð¡A¦³Ãö¨Ï¥Î¶O¥Î¤ÀÅu.xls½d¨Ò¤¤¡A²£¥ÍºÃ°Ý¦³¤T¡G
1.¦p¦óÁôÂÃMacro1¬¡­¶Ã¯¡C
2.°£­º­¶¤u§@ªí¯Á½X¡C
3.§Ú¬Ýexcel4.0»y¨¥»Plotus 123»á¬°¯«¦ü¡A¤£ª¾¥Î¥Ø«eexcel 2007©Îexcel2010¬O§_¥i¥H¼¶¼g¡C
Lin

TOP

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

¦^´_ 15# lin


1.¦p¦óÁôÂÃMacro1 SHEET?
ANS:³o¥u¬O¤@¯ëªº¤u§@ªí«D±`ÁôÂáA¥u¬O¸û¯S§Oªº³¡¤À¬O EXCEL4.0¤u§@ªí¡A§@ÁôÂÃ«á ¦bVBE½s¿è¾¹¤º¬O¬Ý¤£¨ìªº
¤u§@ªí«D±`ÁôÂûyªk³q±`¬°ActiveWorkbook.Sheets("Macro1").Visible = 2
¸Ñ°£¤u§@ªí«D±`ÁôÂûyªk³q±`¬°ActiveWorkbook.Sheets("Macro1").Visible = -1

2.°£­º­¶¤u§@ªí¯Á½X?
ANS:³o­ÓÀɮתº³o­Ó³¡¤À¬O¨Ï¥Î 4.0¥¨¶°ªí»P¥¨¶°©w¸q¨Ó»s§@¡A¬O§޳N¡A¤£¹L­n¤F¸Ñ­nªá¶O¤@ÂI®É¶¡
§A¥i¥H¥ý°Ñ¦Ò³o¤@¶Khttp://www.officefans.net/cdb/viewthread.php?tid=59862&extra=&page=1

3.§Ú¬Ýexcel4.0»y¨¥»Plotus 123»á¬°¯«¦ü¡A¤£ª¾¥Î¥Ø«eexcel 2007©Îexcel2010¬O§_¥i¥H¼¶¼g?
ANS:2007/2010¥i¥H¨Ï¥Îexcel4.0¥¨¶°ªí¡A¤]¥i¥H¼¶¼g

TOP

·PÁ«ü¾É¡A¸Õ¸Õ¬Ý¡C

TOP

这个还»Ý­n¥Î¨ì§»ªíªº¤\¡H

TOP

¦^´_ 18# avel
EH½×¾Âªºª©¥D¦n.³o­Ó¤£»Ý­n§»ªí.¤â¤u«ö¤@«ö´N¦n

TOP

¬ã¨s¤F¥b¤Ñ没¦³§»¡A©_©Ç©O¡H
¦Z来¬Ý¤F¤G楼­ì来¬O4.0§»°Ú

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD