Private Sub Workbook_Open()
Workbook_SheetActivate ActiveSheet 'lance la macro
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If TypeName(Sh) <> "Worksheet" Then Exit Sub
Dim ac As Range
Application.ScreenUpdating = False
Set ac = ActiveCell
Sh.[A1:W1].Select
ActiveWindow.WindowState = xlMaximized 'taille maximum de la fenêtre
ActiveWindow.Zoom = True 'applique le zoom sur la sélection
ac.Select
End Sub