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
    1. Sub auto_open()
    2. ActiveWindow.Zoom = 58
    3. End Sub