Private Sub CommandButton6_Click() If MsgBox("Imprimer juste les articles à commander ?", vbQuestion + vbYesNo, "QUESTION ...") = vbYes Then
Columns("A:F").EntireColumn.Hidden = False
Range("A1:F1").AutoFilter Field:=6, Criteria1:="commander"
ActiveSheet.PrintOut
Else
Columns("A:F").EntireColumn.Hidden = False
Range("A1:F1").AutoFilter
ActiveSheet.PrintOut
End If
End Sub