Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. The Workbooks property is a member of the Application object and returns a reference to the Workbook object specified by the index v
Sub changePro()
    Workbooks(1).Windows(1).WindowState = xlNormal
    Workbooks(1).Windows(1).Width = 500
    Workbooks(1).Windows(1).Height = 300
End Sub