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

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


--
jetted
------------------------------------------------------------------------
jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532
View this thread: http://www.excelforum.com/showthread...hreadid=558375