Hello All,

I am encountering the following error message when I try to generate a PDF from a checkbox list of multiple sheets. "Run-time error '1004': Document not saved. The document may be open, or an error may have been encountered when saving."

Any help would be appreciated with helping this problem, I do not have any other applications or PDFs open on my PC that could be causing the error. The last section of the code is what gets highlighted when I debug:

Selection.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:="C:\temp\temp.pdf", _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=True


Please Login or Register  to view this content.