Sub RapidPrint_CUSTOMER()
Application.ScreenUpdating = False
Sheets("CUSTOMER").Select
Range("$A$1:$M$38").Select
PRINT_PAGE_SETUP_CUSTOMER
Application.Dialogs(xlDialogPrinterSetup).Show 'montre le choix d'imprimantes
ActiveSheet.PrintOut
Range("A1").Select
Application.ScreenUpdating = True
End Sub
----------------------------------------------------------------
Sub PRINT_PAGE_SETUP_CUSTOMER()
With ActiveSheet.PageSetup
.PrintArea = "$A$1:$M$38"
.CenterHorizontally = True
.CenterVertically = True
.Orientation = xlLandscape
.PaperSize = xlPaperLetter
.BlackAndWhite = False
.LeftMargin = Application.InchesToPoints(0.1)
.RightMargin = Application.InchesToPoints(0.1)
.TopMargin = Application.InchesToPoints(0.1)
.BottomMargin = Application.InchesToPoints(0.1)
.HeaderMargin = Application.InchesToPoints(0.1)
.FooterMargin = Application.InchesToPoints(0.1)
End With
End Sub