Excel is changing format when running vba print code

[lr1234]

I'm using the code below to print the tabs in my worksheet to PDF, but for reason I can't figure out the formatting of the lines is changing to bold. I dont understand why this is happening. I want it to print like it would when I print manually but I also want to use a code and get it done fast since I have lot of tabs to go through.

Sub PrintPDF()
Dim ws As Worksheet
Path = "T:\some path"
For Each ws In ActiveWindow.SelectedSheets
ws.ExportAsFixedFormat xlTypePDF, Path & "\" & ws.Name & " - RPOTest.pdf"
Next ws
End Sub

This is how it is printing using my code:

This is how it prints when I print manually:

 

[Joe4]

I have seen that too. I think it happens when printing to PDF. I worried too much about it.

I found this article, where Microsoft seems to acknowledge that this happens (not in the original post, but is brought up in a reply by the OP), but didn't really seem to have any good solution:

Excel Create PDF\Export as PDF Font Issues

Hello, I am trying to use the export to PDF feature in Excel. I notice that when I use this method vs. printing to PDF (using Microsoft Print to PDF printer), the font does not come out right. I

answers.microsoft.com

 

[lr1234]

I have seen that too. I think it happens when printing to PDF. I worried too much about it.

I found this article, where Microsoft seems to acknowledge that this happens (not in the original post, but is brought up in a reply by the OP), but didn't really seem to have any good solution:

Excel Create PDF\Export as PDF Font Issues

Hello, I am trying to use the export to PDF feature in Excel. I notice that when I use this method vs. printing to PDF (using Microsoft Print to PDF printer), the font does not come out right. I

answers.microsoft.com

It dawned on me while reading your post that I should try to Print to PDF instead of export or save to pdf. I'll try that and let you know if it works.