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:
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: