To change the values of the WindowState, Width, and Height properties of the Excel application window, you must explicitly reference the Application object : Application Windows « Application « VBA / Excel / Access / Word
To change the values of the WindowState, Width, and Height properties of the Excel application window, you must explicitly reference the Application object
Sub changeSize()
Application.WindowState = xlNormal
Application.Width = 600
Application.Height = 450 End Sub