Hi All,

As the title suggests, I am looking to export and save an excel sheet as a PDF to a specific file location.

I am currently using the code below, which works perfect, however I would like to know if there is a way to redirect the save to open a "save as" box should an error occur trying to save to the location listed

Sub PDF()
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=Environ("USERPROFILE") & "\SharePoint\OFS Operations - Job Briefing Recor\\" & Cells(2, 1).Value & " - " & Cells(2, 2).Value & " - " & Cells(3, 2).Value & ".pdf", _
OpenAfterPublish:=True
End Sub
The reason I ask this, is I am saving the PDF to a Synced SharePoint folder on the users computer, should this fail to sync or be removed by mistake, I dont want my code to return an error, and instead redirect to a manual save as box

Thanks in advance to any replies