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

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

¥»©«³Ì«á¥Ñ 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

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

TOP

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

TOP

¦^´_ 13# yujen16

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

TOP

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

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD