Re,
Oups....un petit oubli...remplace:
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=chemin, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
par
Ws.ExportAsFixedFormat Type:=xlTypePDF, Filename:=chemin, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
....Acivesheet = feuille active; Ws = toutes les feuilles
Sub exportPDF()
Dim Ws As Worksheet, nompdf As String, dossier As String
For Each Ws In ThisWorkbook.Worksheets
'dossier = ThisWorkbook.Path
dossier = "C:\Users\maison\Desktop\Nouveau dossier\" ' a adapter
nompdf = Ws.Range("B7")
chemin = dossier & nompdf
Ws.ExportAsFixedFormat Type:=xlTypePDF, Filename:=chemin, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
Next Ws
End Sub
Cordialement,