Sub test()
Dim Lt As String, Root As String, F As Worksheet
Root = ThisWorkbook.Path
'Root = "C:\Users\x\Desktop"
For Each F In ThisWorkbook.Worksheets
If F.Name <> "Feuil1" And F.Name <> "Feuil2" Then
Lt = IIf(Lt = "", "", Lt & "!") & F.Name
End If
Next
If Lt <> "" Then
Worksheets(Split(Lt, "!")).Select
ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, Filename:=Root & "\Fichier-V9.pdf", _
OpenAfterPublish:=True
Else
MsgBox "Rien à Exporter"
End If
End Sub