Button.Activate Method

Activates the Button.

Namespace:  Microsoft.Office.Tools.Excel.Controls
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Public Function Activate As Object
public Object Activate()

Return Value

Type: System.Object
true if the Button is activated; otherwise, false.

Examples

The following code example adds two Button controls to a worksheet and then programmatically activates the second button by using the Activate method.

This example is for a document-level customization.

Private Sub ActivateControl()
    Dim Button1 As Microsoft.Office.Tools.Excel.Controls.Button = _
        Me.Controls.AddButton(Me.Range("B2", "C3"), "Button1")
    Button1.Text = "Button 1" 

    Dim Button2 As Microsoft.Office.Tools.Excel.Controls.Button = _
        Me.Controls.AddButton(Me.Range("B5", "C6"), "Button2")
    Button2.Text = "Button 2"

    Button2.Activate()
End Sub
private void ActivateControl()
{
    Microsoft.Office.Tools.Excel.Controls.Button button1 =
        this.Controls.AddButton(this.Range["B2", "C3"],
        "button1");
    button1.Text = "Button 1";

    Microsoft.Office.Tools.Excel.Controls.Button button2 =
        this.Controls.AddButton(this.Range["B5", "C6"],
        "button2");
    button2.Text = "Button 2";

    // Programmatically activate the second button only.
    button2.Activate();
}

.NET Framework Security

See Also

Reference

Button Class

Microsoft.Office.Tools.Excel.Controls Namespace