Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim ws As Worksheet
If ActiveSheet.Name = "modèle" Then
For Each ws In Worksheets
With ws.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = Sheets("modèle").Range("A1")
.CenterFooter = ""
.RightFooter = ""
End With
Next
Else
Cancel = True
MsgBox "Vous ne pouvez pas imprimer sans être dans l'onglet modèle"
End If
End Sub