¦p¦ó¦b«ü©w®É¶¡¦Û°Ê¦sÀɤÎÃö³¬EXCEL
- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 6# cdkee
°Ý1) ¨S¿ù Application.OnTime "08:22:56", "ThisWorkbook.EX"
µ{§Ç¦b ThisWorkbook,Sheet1,Sheet2 ....µ¥ ª«¥ó¼Ò²Õ »Ý«ü©ú, µ{§Ç¦b¤@¯ë¼Ò²Õ(Module)¤º«h¤£»Ý«ü©úµ{§Ç©Ò¦bªº¼Ò²Õ.
°Ý2) Private Sub EX() <---¦b³oÓ¨Ò¤l¥ÎPrivate¦³¨S¦³¯S§O·N«ä?
Sub EX() => Public Sub EX(),¬O¤½¥Îªº¨ä¥Lª«¥ó¼Ò²Õ©Î ¤@¯ë¼Ò²Õ(Module)³£¥i¥H¨Ï¥Îªº.
Private Sub EX() ¬O¨p¥Îªº,¨ä¥Lª«¥ó¼Ò²Õ©Î ¤@¯ë¼Ò²Õ(Module) µLªk¨Ï¥Î.
¨Ò¦p¦³Private Sub EX() ¤Î Sub Example() ¨âµ{§Ç ¦b«ü¥O [¤u¨ã]->[¥¨¶°] ¥u¥i¥H§ä¨ìSub Example()
°Ý3) Private Sub Workbook_BeforeClose(Cancel As Boolean)»PPrivate Sub Workbook_BeforeClose()¦³¤°»ò¤À§O?
Private Sub Workbook_BeforeClose(Cancel As Boolean) ¬O©óÃö³¬Workbook®Éªº¤º«ØIJ°Ê¨Æ¥ó
Private Sub Workbook_BeforeClose()¦]»P¤Wz¤º«ØIJ°Ê¨Æ¥ó¦WºÙ¬Û¦P,¦p¦bThisWorkbookª«¥ó¼Ò²Õ¤º¬O¤£¤¹³\ªº.
°Ý4) ThisWorkbook.Save <---¬O§_º|¼g³oÓ? ¬Ý¤£©ú¥Õ§Aªº·N«ä
°Ý5) ThisWorkbook.Close 1 ¥¿¦¡¼gªk ThisWorkbook.Close SaveChanges:=True (VBA False=0, True=1)
°Ý6) Sub AUTO_OPEN()...¤£¥ÎPrivate Sub Workbook_Open()¬O¦]¬°¦bModuleªºµ{¦¡¤£¥i¥ÎPrivate?©Î¦³¨ä¥L¦]¯À?
Private Sub Workbook_Open() ¬OWorkbook¶}±Ò®Éªº¤º«ØIJ°Ê¨Æ¥ó,©ñ©óModuleªºµ{¦¡½X¤¤,¤£·|©óÀɮ׶}Àɮɦ۰ʰõ¦æ.
°Ý7) ¤p½ú¤´µM¤À¤£²M¡A¦ó®É¥ÎSheet/ThisWorkbook¡A¦ó®É¥ÎModule?
¦h¦h½m²ß«á·|¿Ä·|³e³qªº!! |
|
|
|
|
|
|