Opening Excel spreadsheets maximized

Question

for a better user experience, I would like to make a spreadsheet downloaded from the web maximized when it is opened through the user's desktop MS Excel 2010 program.

Can this be achieved through preference configuration or is there Macro involved?

Thanks! Che

Answer 1

This is a simple macro to do what you ask. You need to put it in the workbook module.

Private Sub Workbook_Open()
    Application.WindowState = xlMaximized 'maximize Excel
    ActiveWindow.WindowState = xlMaximized 'maximize the workbook in Excel
End Sub