Sub imprimeClasseur()
Dim I As String
I = InputBox("Saisir le nom de l'onglet à imprimer", "Impression")
Debug.Print I
Do While I <> "tata" Or I <> "toto"
MsgBox ("Saisie non valide")
I = InputBox("Saisir le nom de l'onglet à imprimer", "Impression")
Loop
'With ActiveWorkbook.Sheets(I)
' .PageSetup.Orientation = xlPortrait
' .CenterFooter = "Calculs pour "
'
' .LeftMargin = Application.InchesToPoints(0.7)
' .RightMargin = Application.InchesToPoints(0.7)
' .TopMargin = Application.InchesToPoints(0.75)
' .BottomMargin = Application.InchesToPoints(0.75)
' .HeaderMargin = Application.InchesToPoints(0.3)
' .FooterMargin = Application.InchesToPoints(0.3)
' .CenterHorizontally = True
' .CenterVertically = True
' .PrintGridlines = False
' .BlackAndWhite = False
'
'End With
ActiveWorkbook.Sheets(I).PrintOut
End Sub