Workspace and view zoom
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 |
Workspace and view zoom
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 |
All times are GMT +1. The time now is 01:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com