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

½Ð°Ý¸ê®ÆÅçÃҮɬ°¦ó¨S¥X²{­Ë¤T¨¤§Î¥i¨Ñ¿ï¨ú²M³æ

½Ð°Ý¸ê®ÆÅçÃҮɬ°¦ó¨S¥X²{­Ë¤T¨¤§Î¥i¨Ñ¿ï¨ú²M³æ

½Ð°Ý§Úªº¤u§@ªí¦b¸ê®ÆÅçÃҮɬ°¦ó¨S¥X²{¤U©Ô¦¡¿ï³æ¥i¨Ñ¿ï¨ú?

²M³æÅçÃÒ.rar (6.87 KB)

ÁÂÁÂHsien
°ÝÃD¸Ñ¨M¤F

TOP

¦^´_ 13# yujen16

¤u¨ã/¿ï¶µ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

½Ð°ÝHsieh ª©¥D
§Ú¬Ooffice 2003¡@ª©¡@¦b­þ¸Ì³]©w¡H

TOP

·PÁª©¥»¦^ÂÐ,excel«Ü¯E¤j,¾ÇµL¤î¹Ò,­n§ó¥[§Ö¸}¨B¾Ç²ß

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-12-13 14:28 ½s¿è

¦^´_ 7# aa7551

®Ú¾ÚVBA»¡©ú:
Workbook.DisplayDrawingObjects ÄÝ©Ê
·|¶Ç¦^©Î³]©w¹Ï§ÎªºÅã¥Ü¤è¦¡¡C¥iŪ¼gªº Long¡C
¤]´N¬O»¡DisplayDrawingObjectsÄݩʤD¬O¥Î¨Ó³]©w¤u§@鷺¦UºØ¹Ï§ÎªºÅã¥Ü¤è¦¡
¨ä±`¼Æ¥Nªí·N¸q¦p¤U
xlDisplayShapes Åã¥Ü©Ò¦³¹Ï®×¡C
xlPlaceholders ¶ÈÅã¥Ü¹w¯d¦ì¸m¡C
xlHide ÁôÂéҦ³¹Ï®×¡C
©Ò¥H¡A¦bVBA±Ô­z®É»yªk¦p¤U
ThisworkBook.DisplayDrawingObjects= xlDisplayShapes 'Åã¥Ü©Ò¦³¹Ï®×¡C
ThisworkBook.DisplayDrawingObjects= xlHide  'ÁôÂéҦ³¹Ï®×¡C
µù:2007ª©¥»¤w¨ú®øxlPlaceholders¿ï¶µ
¥H¤WVBA»¡©ú¡A¤p§Ì¤´¦³¤@ÂI¤£²M·¡
xlDisplayShapes Åã¥Ü©Ò¦³¹Ï®×¡C
xlPlaceholders ¶ÈÅã¥Ü¹w¯d¦ì¸m¡C
³o2­Ó±`¼Æ¶Ç¦^ªºµ²ªG®É¦A¬Ý¤£¥X­þ¸Ì¤£¦P?
¤£ª¾©Ò¿×ªº¹w¯d¦ì¸m¬O¦óºØ±¡§Î?
ÁٽЪ¾¹Dªº«e½ú¤£§[«ü±Ð
ÁÂÁÂ!
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

³o­Ó¬O­Ó¦n°ÝÃD

¥i¥H¬Ý¥X ¦pªG§Ú­Ì·QÅýÅçÃÒ²M³æ
¤£Åã¥Ü¥X²M³æ ¦³¨âºØ¤èªk ¤@­Ó¦bÅçÃÒ¤º
¤@­Ó¦bª«¥ó¤º
¦Ó¥B¥i¥H¤¬¬Û­«Å|Àx¦s

¹ïÅçÃÒ«OÅ@¬O¤@­Ó¥]¸Ë¤èªk

TOP

¦^´_ 4# yujen16


    ¤u¨ã/¿ï¶µ¤º³]©w¦p¹Ï
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁÂoobird¶W¯Åª©¥D
¦A°Ý¤@¤U¶W¯Åª©¥D
§Úªº¥\¤OÁÙ¤£¨ì¥h§ó§ï³o¼Ëªº³]©w,¦p¦ó§â³o³]©wÅܦ¨excelªºªì©l³]©w
yujen16 µoªí©ó 2010-12-9 15:17



    ³o¼ËÀ³¸Ó©ú¥Õ¤F¡C
a.gif

TOP

½Ð±Ðoobirdª©¥»,DisplayDrawingObjects Äݩʤ¤»¡©ú:±`¼ÆxlDisplayShapes--Åã¥Ü©Ò¦³§Îª¬,¤£¤Ó¤F¸Ñ¨ä·N«ä,¥i§_¸Ñµª,¥t¥~«e­±¥X²{-4104-,³o¦³¦ó³B¥i¬d¸ß¨ä·N¸q

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD