Excel Export to PDF Font Size and Style

[chegra26]

I have a custom user form that I have set up to automatically save as PDF, however when I print the document, the font is small. What is the VBA code to set Font settings upon exporting to PDF? My code is as follows: Everything looks great except for when it prints.

'Code to Print the form or Export to PDF

sh.PageSetup.PrintArea = "$A$1:$N$106"



'sh.PrintOut copies:=1, IgnorePrintAreas:=False

sh.ExportAsFixedFormat xlTypePDF, ThisWorkbook.Path & Application.PathSeparator & frmform.txtlname.Value & ", " & frmform.txtfname.Value & " " & frmform.txtclient.Value & ".pdf"


MsgBox "Client Information has been printed.", vbOKOnly + vbInformation, "Print"

Application.ScreenUpdating = True
Application.DisplayAlerts = True


End Sub

 

[jolivanes]

What are your Printer Setup settings? Your print area is rather big so it looks like it might be set to fit to one page.

 

[chegra26]

What are your Printer Setup settings? Your print area is rather big so it looks like it might be set to fit to one page.

I have adjusted the print area settings but the font still prints rather small. The printer Setup settings are not defined in the VBA. The code only saves the document as a PDF

 

[jolivanes]

If you go to "Page Setup" - "Page" - "Scaling" - "Adjust To", what value do you see?

 

[chegra26]

right now it is on custom 100% but i have tried None, Fit to Printer margins and Reduce to printer margins. Maybe it would be easier to just export the spreadsheet to word. Can you help with the VBA to export to a word document?

 

[jolivanes]

Why would you not try to fix the problem?
Looks like you need to check all your settings.