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 = 1
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
MsgBox (libel)
With .PageSetup
.Leftfooter = "&""" & police & ",normal""" & "&" & taille & libel
.LeftFooter = libel
End With
.PrintPreview
'.PrintOut
Next
End With
Application.EnableEvents = True
End Sub