Sub Imprimer()
Dim n As Integer
Dim libel As String
Dim police As String
Dim taille As String
Dim pge As Integer
'détermination police et taille
police = "Arial"
taille = 3
n = Application.InputBox("Nombre de copies :", "Imprimer", 1, , , , , Type:=1)
Application.EnableEvents = False
With ActiveSheet
For pge = 1 To Val(n)
libel = " " & pge & " de " & n
With .PageSetup
.LeftFooter = "&""" & police & ",normal""" & "&" & taille & libel
End With
.PrintOut
Next
End With
Application.EnableEvents = True
End Sub