Check that all tabs are at 100% scaling

[RichJH]

Hi,

I have multiple workbooks and would like to check that what the scaling is on each of the tabs before I print it out. Maybe some script that gives me a report tab maybe.

Thanks

Rich

 

[RichJH]

Tried that but could not grab that parameter, thanks o7

 

[tyija1995]

Thanks @Peter_SSs for the feedback on the macro - I'm still at quite a basic level with VBA so this is much appreciated. I assume "On Error GoTo 0" is how you revert the "On Error Resume Next" statement?

 

[Peter_SSs]

Tried that but could not grab that parameter, thanks o7

Tried what? Could not grab what parameter? What was the message or symptoms?

Thanks @Peter_SSs for the feedback on the macro -
I assume "On Error GoTo 0" is how you revert the "On Error Resume Next" statement?

You're welcome, and "Yes"