This documentation is archived and is not being maintained.

Workbook.Activate Method

Office 2007
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.

Visual Basic for Applications
Workbooks("BOOK4.XLS").Activate



Show: