Activating a Workbook

See Also

Activating a workbook using the Activate method puts the workbook in the active window. The following procedure activates the open workbook named "MyBook.xls."

Sub MakeActive()
    Workbooks("MyBook.xls").Activate
End Sub