I have a spreadsheet that prints to PDF with the click of a button. The relevant VBA code is shown below. This print to PDF code has functioned flawlessly for years, but out of nowhere, people are starting to get strikethrough text on their PDFs. This issue does not occur with everyone (it doesn’t occur for me). The strikethrough text also doesn’t show up in the spreadsheet itself, just the PDF.
Range(printrange).ExportAsFixedFormat Type:=xlTypePDF, filename:=filepath, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
I made sure that everyone that has the issue is printing using the same PDF printer as me, but that hasn’t resolved the problem. Also, we discovered that this issue doesn’t occur when they manually print, only when they use the button to print to PDF.
I am open to any suggestions. Thank you for your help!
You need to sign in to view this answers
Leave feedback about this