Zoom setting doesn't save

    We have an Excel spreadsheet we use for work to save results and performance data. Because of the size we use a zoom setting of 58% for our display. Each day, when we load up the sheet, the zoom resets back to 100%. What do we need to do to ensure our desired zoom is saved?


    -Sturla

    Re: Zoom setting doesn't save


    Hi


    Welcome to Ozgrid forum


    You could put the following code in a module

    Code
    Sub auto_open()
ActiveWindow.Zoom = 58
End Sub

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login