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

[µo°Ý] ¤@ª½­«·s­pºâ

[µo°Ý] ¤@ª½­«·s­pºâ

¥»©«³Ì«á¥Ñ hungrn ©ó 2020-2-6 16:23 ½s¿è

¦U¦ì¥ý¶i¦n
¼g¤F¤@­Óvba,¤£ª¾¬Æ»ò­ì¦],¾É­P¥ô¦ó¤À­¶,¥ô¤@­Ó¦ì¸m,¨C«ö¤@¤UÀx¦s®æ(µL¤º®e¤]µL¨ç¼Æ),¦ý¨S¦³¿é¤J¥ô¦óªF¦è,³£·|­«·s­pºâ¤@¦¸(·s¼W¤@­Ó¥þªÅ¥Õ¤À­¶,¤]¬O¦Pª¬ªp)
§ä¹L¤F¥N½X,¨S¦³Worksheet_Change¨Æ¥ó,³]©w¤F¤¤Â_ÂI,ÁÙ¬O¬dµL­ì¦]..
½Ð°ÝÁÙ­n©¹­þ­Ó¤è¦V¥h§ä´M°ÝÃD..
beg9g-61kk2.gif

¥t¥~..¨S¦³¶}¥¨¶°®É..¸ò¤W­z³£¦P¼Ë¦aª¬ªp..¤@ª½­pºâ

TOP

«á¨Ó..§Ú§âµL¬ÛÃöªº¨ä¥¦¤À­¶EnableCalculationÃö³¬,¥u¯d»Ý­pºâªº¤À­¶¤Î¬ÛÃöªºÃöÁp,¼È®É¸Ñ¨M¤F°ÝÃD
¦]¬°¦³±Nªñ30­Ó¤À­¶,5000¦h µ§¸ê®Æ,«Ü¦h¤À­¶³£¦³¥æ¤e»Ý­n¸ê®Æ..
¦³¬Û¦P°ÝÃDªº,¥i¥H¸Õ¸Õ¥H¤U¤èªk
For n = a To b
Worksheets(n).EnableCalculation = False
Next

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD