- ©«¤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
|
¦^´_ 1# brabus
¸Õ¸Õ¬Ý- Option Explicit
- Private Sub Workbook_Open()
- Names.Add "UpdateDate", Date - 90, False
- '´ú¸Õ®É½Ð¥ý¦b¦¹©w¸q¦WºÙ µM«á§R±¼³o¦æµ{¦¡½X
- DayCheck
- End Sub
- Private Sub DayCheck()
- Dim Msg As Boolean, N As Name
- For Each N In Names
- If N.Name = "UpdateDate" Then 'À˹î§ó·s¤é´Á¬O§_¦s¦b
- Msg = True
- Exit For
- End If
- Next
- If Not Msg Then
- §Aªº§ó·sµ{¦¡
- ElseIf CDbl(Date) - [UpdateDate] >= 90 Or Day(Date) = 1 Then '
- If Day(Date) = 1 Then '¦p¬O¨C¤ëªº²Ä1¤Ñ
- Select Case Month(Date) '¤ë¥÷
- Case 1, 4, 7, 10
- MsgBox "§ó·sµ{¦¡"
- §Aªº§ó·sµ{¦¡ '°õ¦æ§ó·sµ{¦¡
- End Select
- Else '>=90¤Ñ
- MsgBox "§ó·sµ{¦¡"
- §Aªº§ó·sµ{¦¡ '°õ¦æ§ó·sµ{¦¡
- End If
- End If
- End Sub
- Private Sub §Aªº§ó·sµ{¦¡()
- '§ó·sµ{¦¡½X
- '§ó·sµ{¦¡½X
- '§ó·sµ{¦¡½X
- '§ó·sµ{¦¡½X
- Names.Add "UpdateDate", Date, False '³Ì«á§ó·s¤é´Á
- End Sub
½Æ»s¥N½X |
|