Private Sub imprime_Click()
Dim choix As Byte, i&, a&(), j&
choix = MsgBox("Recto-verso ?", 3, "Imprimer")
If choix = 2 Then Exit Sub
For i = 1 To Worksheets.Count
Worksheets(i).PageSetup.FitToPagesWide = 1 '1 page en largeur
ReDim Preserve a(1 To i)
a(i) = ExecuteExcel4Macro("GET.DOCUMENT(50,""" & Worksheets(i).Name & """)")
Next
For i = 1 To UBound(a)
For j = 1 To a(i) Step IIf(choix = 6, 2, 1)
Worksheets(i).PrintPreout From:=j, To:=j
Next
Next
end sub