Essaie ceci :
Sub PDF()
Dim LeNom As String, LaDate As String, LeRep
LeNom = Range("B2").Value
LaDate = Format(Date, "yyyy.mm.dd")
LeNom = LeNom & " - " & LaDate & ".pdf"
LeRep = Application.GetSaveAsFilename(LeNom, "PDF Files (*.pdf), *.pdf")
If LeRep Then
ActiveSheet.ExportAsFixedFormat xlTypePDF, LeRep
MsgBox "Le fichier a bien été créé"
End If
End Sub
Cordialement.