Workbook.Activate method (Excel)
Activates the first window associated with the workbook.
Syntax
expression.Activate
expression A variable that represents a Workbook object.
Remarks
This method won't run any Auto_Activate or Auto_Deactivate macros that might be attached to the workbook (use the RunAutoMacros method to run those macros).
Example
This example activates Book4.xls. If Book4.xls has multiple windows, the example activates the first window, Book4.xls:1.
Workbooks("BOOK4.XLS").Activate
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.