How to set 100% view after converting pdf

[hobbes11]

Each time after I save as pdf using VBA, the zoom size is always more than 100%, how to set 100% always?

 

[BrianJN1]

Each time after I save as pdf using VBA, the zoom size is always more than 100%, how to set 100% always?

Do you mean that the PDF save increases the size of your excel sheet?
My PDF save line is:
"Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Dir\Filename" & Format(Date, "yyyymmdd") & ".pdf", Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
True "

My PDF shows up at 163%. When I close that file my Excel is normal.
Am I understanding you correctly?

 

[hobbes11]

I mean in excel file is 100% but when pdf the pdf file is at 120%

 

[BrianJN1]

It seems that my PDF client has a default of 163%. I can't see how to override that with VBA.
I assume that is much like your position.