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?


  • Re: Zoom setting doesn't save


    Welcome to Ozgrid forum

    You could put the following code in a module

    1. Sub auto_open()
    2. ActiveWindow.Zoom = 58
    3. End Sub