Option Explicit
Private Sub Worksheet_Activate()
With ActiveSheet.PageSetup
.LeftHeader = "Entreprise TOTO"
.CenterHeader = "Mois de " & Format(Date, "mmmm") & " - " & Feuil3.Name 'utilisation du codename
.RightHeader = "Impression du " & Date
End With
End Sub