Private Sub GoCellDay()
Dim C As String
With ActiveSheet
If Time < .[I3] Then
C = "I"
ElseIf Time < .[K3] Then
C = "K"
Else
C = "M"
End If
.Cells(Day(Date) + 3, C).Select
End With
End Sub
Private Sub Workbook_Open()
Worksheets(Month(Date)).Select
Call GoCellDay
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
'ne rien faire si la feuille active n'est pas celle du mois en cours
If Sh.Index = Month(Date) Then Call GoCellDay
End Sub
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
ActiveSheet.[A1].Select
End Sub