Bonjour
Modifies la macro comme suit
Private Sub Workbook_Open()
Dim Sem As Integer
Dim Ligne As Long
Dim Colonne As Integer
Sem = DatePart("ww", Date, vbMonday, vbFirstFourDays)
Ligne = 1 + (((Sem - 1) \ 4) * 18)
Colonne = 2 + (((Sem - 1) Mod 4) * 13)
Application.Goto Sheets("2012").Cells(Ligne, Colonne), scroll:=True
ActiveWindow.ScrollColumn = Application.Max(Colonne - 10, 1)
ActiveWindow.ScrollRow = Application.Max(Ligne - 10, 1)
Cells(Ligne, Colonne).Resize(17, 8).Select
End Sub