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

    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!