Sub Entete()
With ActiveSheet.PageSetup
.RightFooter = "Numero de dossier Diplabo : " & [E7]
End With
nom = InputBox("Feuille a conserver ?")
For Each sh In Sheets
If sh.Name = nom Then existe = True
Next
If existe Then
For Each sh In Sheets
If sh.Name <> nom Then sh.Delete
Next
Else
MsgBox ("Cette page n'existe pas")
End If
End Sub