Bonjour,
Et une autre proposition !
Cdlt.
Private Sub Workbook_Open()
Dim iWeek As Integer, sheetName As String
iWeek = DatePart("ww", Date - Weekday(Date, 2) + 4, 2, 2)
sheetName = "S" & Format(iWeek, "00")
Application.Goto reference:=ThisWorkbook.Worksheets(sheetName).Cells(1), scroll:=True
End Sub