Sub Macro2()
Dim chemin$, fich$
chemin = ThisWorkbook.Path & Application.PathSeparator 'à adapter
fich = InputBox("Nom du fichier PDF sans extension :", "PDF")
If fich = "" Then Exit Sub
ActiveSheet.PageSetup.PrintArea = "$B:$O"
ActiveSheet.ExportAsFixedFormat xlTypePDF, chemin & fich, OpenAfterPublish:=True
End Sub