WorkbookBase.RunAutoMacros Method

Runs the Auto_Open, Auto_Close, Auto_Activate, or Auto_Deactivate macro attached to the workbook. This method is included for backward compatibility. You should use the Open, Close, Activate and Deactivate events instead of these macros.

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

Syntax

'Declaration
Public Sub RunAutoMacros ( _
    which As XlRunAutoMacro _
)

public void RunAutoMacros(
    XlRunAutoMacro which
)

Parameters

• which
  Type: Microsoft.Office.Interop.Excel.XlRunAutoMacro

  One of the XlRunAutoMacro values.

Examples

The following code example uses the RunAutoMacros method to run the Auto_Activate macro.

This example is for a document-level customization.

Private Sub WorkbookRunAutoMacros()
    Me.Activate()
    Me.RunAutoMacros(Excel.XlRunAutoMacro.xlAutoActivate)
End Sub

private void WorkbookRunAutoMacros()
{
    this.Activate();
    this.RunAutoMacros(Excel.XlRunAutoMacro.xlAutoActivate);
}

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

WorkbookBase Class

Microsoft.Office.Tools.Excel Namespace