´Æ¤âªºexcel¹Bºâ°ÝÃD¡A¦p¦ó§ïµ½??
- ©«¤l
- 365
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 406
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-11
- ³Ì«áµn¿ý
- 2024-8-24
|
¦^´_ 35# c_c_lai
C¤j©p¯u¬O¤Ó²Ó¤ß¤F¡A·PÁ§A¡A§Ú¥ý¬ã¨s¬Ý¬Ý¡AÁÂÁ |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¥»©«³Ì«á¥Ñ c_c_lai ©ó 2016-1-29 07:38 ½s¿è
¦^´_ 34# ÂŤÑÄR¦À
§Ú«e«e«á«á¬d¬Ý¤F§A»Pã´£³¡ªLª©¤j¤W¶Ç¤À¨ÉªºÀɮסA
µo²{°ÝÃD¤´µM¥X¦Û©ó§Aªº¦Û¦æ¦A¾ã¦X¡Aã´£³¡ªLª©¤j
¤W¶Çªº¤º®e³£¨S¥[¤J Workbook_Open() ªº°õ¦æ¤º®e¡A
¬Æ¦Ü¦b²Ä¤@¦¸µ¹ªº Xl0000328.rar ¤]¥ç±N¥¦ Marked ±¼¡A
§A¥u±N¥¦¤À¨É¼Ò²Õ¤ºªº Sub ²Îp() ª½±µ¶K¤J¨ì§A쥻ªºÀɮפº
©Ò¥H¤~·|³y¦¨¥¼¯à¥¿±`°õ¦æªºì¦]¡C¬°À°§U§A§ó¯à©úÁAª©¤j
¼Ò²Õªº¹B§@¡A¯S¤©¦b¨ä¼Ò²Õ¤º¨C¤@´`Àô²Ó³¡¤ÀªR¸Ñ»¡¡A§Æ±æ§A
¯à¶i¤@¨B¾Ç²ß¨ì¦p¦ó¹B¥Î¡A¦P®É¯à¼W¶i§A¥»¨ªº¦Û§ÚÆ[¹î¤O¡C
§Ú±N¤T¤èªºµ{¦¡¼Ò²Õ¤©¥H²Õ¦X¤W¶Ç¤W¨Ó¡A§A´ú¸Õ¬Ý¬Ýµ²ªG¦p¦ó¡C
¸ÑÀ£«á«Kª½±µ¥Î¥¦¨Ó°õ¦æ´ú¸Õ¡A¦p¦¹¤~±o¥HÆ[´ú¨ä´ú¸Õµ²½×¡C
©ú²ÓÅÜ°Ê°O¿ý.rar (178.89 KB)
|
|
|
|
|
|
|
- ©«¤l
- 365
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 406
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-11
- ³Ì«áµn¿ý
- 2024-8-24
|
¦^´_ 33# c_c_lai
¥i¬O¤§«e³o¼Ë³]©w¯à¶]¡A¬°¤°»ò¥[¤Fã¤jªºµ{¦¡¤§«á´N¤£¯à¶]©O?? |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 31# ÂŤÑÄR¦À
§A§â ThisWorkbook ¸Ìªº¨ç¼Æ¤º®eµy¥[²§°Ê
µM«á¤©¥HÀx¦s«á¡AÃö³¬«¶} Excel¡G- Option Explicit
- Private Sub Workbook_BeforeClose(Cancel As Boolean)
- Application.RTD.ThrottleInterval = 2000
- Application.Calculation = xlCalculationAutomatic
- End Sub
- Private Sub Workbook_Open()
- Application.RTD.ThrottleInterval = 0
- Application.Calculation = xlCalculationManual
- End Sub
½Æ»s¥N½X ק令¡G- Option Explicit
- Private Sub Workbook_BeforeClose(Cancel As Boolean)
- Application.RTD.ThrottleInterval = 0
- Application.Calculation = xlCalculationManual
- End Sub
- Private Sub Workbook_Open()
- Application.RTD.ThrottleInterval = 2000
- Application.Calculation = xlCalculationAutomatic
- End Sub
½Æ»s¥N½X ¦A«·s¸Õ¸Õ¬Ý¡C
³o«K¬Oã´£³¡ªLª©¤j°Ý§Aªº°ÝÃD¡C |
|
|
|
|
|
|
- ©«¤l
- 365
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 406
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-11
- ³Ì«áµn¿ý
- 2024-8-24
|
¦^´_ 30# ã´£³¡ªL
·Ç¤j¡A§Ú¤£¤ÓÀ´§Aªº·N«ä |
|
|
|
|
|
|
- ©«¤l
- 365
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 406
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-11
- ³Ì«áµn¿ý
- 2024-8-24
|
¦^´_ 29# c_c_lai
¦³¡A¤@ª½¦³ÅÜ°Ê |
|
|
|
|
|
|
- ©«¤l
- 2825
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2881
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-9-15
|
¦^´_ 28# ÂŤÑÄR¦À
Private Sub Workbook_Open()
Call ²Îp_±Ò°Ê
Application.RTD.ThrottleInterval = 0
Application.Calculation = xlCalculationManual '¶}±ÒÀÉ®×´N±N¡e¦Û°Ê«ºâ¡fÃö³¬¡A«ç¥i¯àIJ°Ê¡eCalculate¡f¡@
End Sub |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 28# ÂŤÑÄR¦À
¨º§A¦AÆ[¹î¤@¤U F2 Ä檺¼Æ¾Ú¦³¨S¦³¤@ª½¦bÅÜ°Ê¡H
¦p¨S¡A«h§A¥²¶·«·s¦A¦¸±Ò°Ê¨é°Óªº³nÅé¡C |
|
|
|
|
|
|
- ©«¤l
- 365
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 406
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-11
- ³Ì«áµn¿ý
- 2024-8-24
|
¥»©«³Ì«á¥Ñ ÂŤÑÄR¦À ©ó 2016-1-28 14:12 ½s¿è
¦^´_ 27# c_c_lai
¬Ý24¼ÓºI¹Ï¡AF¦C¦b¬ö¿ý®É¬Û¦P¤]°O¿ý¤F¦Ó¥B³£¬O¦P¼Ë¸ê®Æ¡AF42-F52³£¬O¬Û¦Pªº¡A¦ý¬O¥L¤]°O¿ý¤F¡A¥¿±`¤£À³¸Ó¬O³o¼Ë |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 26# ÂŤÑÄR¦À
§A»¡ "¥i¥H°O¿ý¡A¦ý«o¤£¬O§Ú쥻³]©wªºÅܰʤ~¬ö¿ý"
¦¹¸Ü«ç»¡¡H
§A¶}±ÒÀɮ׫á¡A¥¦·|±q DDE ¶×¤J§Y®É¼Æ¾Ú¡A±µµÛ¥¦«K¦Û°Ê§PÂ_
Á`¶q¦³²§°Ê®É¤~°O¿ý¡A³oÓ¹Lµ{¤£¹ï¶Ü¡H"¤£¬O§A쥻³]©wªºÅܰʤ~¬ö¿ý"
¬O¬Æ»ò±¡§Î¡A¦]§Ú¨S¨é°Óªº³nÅé©Ò¥HµL±q±oª¾®t²§¦b¨ºùØ¡C |
|
|
|
|
|
|