Private Sub CommandButton1_Click()
If OptionButton1 = True Then
Dim fichier As String, fichier2 As String
If CheckBox1 = True Then
fichier = "Q:\FRGrp004\SERVICE ACHATS\PLAN MECANIQUE SYSTEME\PLANS\" & [C12].Value
Sheets("PROD").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=fichier, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=True
End If
If CheckBox2 = True Then
fichier2 = "Q:\FRGrp004\SERVICE ACHATS\PLAN MECANIQUE SYSTEME\PLANS\" & [F12].Value
Sheets("FOURNISSEUR").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=fichier2, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=True
End If
End If
End Sub