This topic has not yet been rated - Rate this topic

Workbook.ActivateEvent Event

Visual Studio 2005

Occurs when the workbook is activated.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

Syntax

public event WorkbookEvents_ActivateEventHandler ActivateEvent

Remarks

When you switch between two windows showing the same workbook, the WindowActivate event occurs, but the ActivateEvent event for the workbook does not occur.

This event does not occur when you create a new window.

Example

The following code example demonstrates a handler for the ActivateEvent event. The event handler displays worksheet Sheet1 when the workbook is activated.

private void WorkbookActivateEvent()
{
    this.ActivateEvent +=
        new Excel.WorkbookEvents_ActivateEventHandler(
        ThisWorkbook_ActivateEvent);
}

private void ThisWorkbook_ActivateEvent()
{
    Globals.Sheet1.Activate();
}

Reference

Workbook Class
Workbook Members
Microsoft.Office.Tools.Excel Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)