Mega Code Archive

 

Categories / VisualBasic Script / Application

 

To change the values of the WindowState, Width, and Height properties of the Excel application window, you must explicitly ref

Sub changeSize()     Application.WindowState = xlNormal     Application.Width = 600     Application.Height = 450     End Sub