Workspace and view zoom

[Martin James Thornhill]

I have a family of 5 worksheets. I have saved them as a workspace for
convenience.

I normally view a sheet at zoom 75% because 10pt Arial is too big for my
eyes. Literally, I prefer to see the bigger picture. 100% is too myopic!

But when I re-open the workspace, I lose the 75% setting and all-but-one
sheets in each workbook reverts to the myopic 100% zoom.

It undermines the convenience that I seek.

How can I permanently fix this?

Kind regards

 

[jetted]

You could try this
Sub auto_open()
ActiveWindow.Zoom = 75
End Sub