Partager via

WorkbookBase.RunAutoMacros(XlRunAutoMacro) Method

  • Reference

Definition

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

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.

public:
 void RunAutoMacros(Microsoft::Office::Interop::Excel::XlRunAutoMacro which);
public void RunAutoMacros (Microsoft.Office.Interop.Excel.XlRunAutoMacro which);
member this.RunAutoMacros : Microsoft.Office.Interop.Excel.XlRunAutoMacro -> unit
Public Sub RunAutoMacros (which As XlRunAutoMacro)

Parameters

which
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 void WorkbookRunAutoMacros()
{
    this.Activate();
    this.RunAutoMacros(Excel.XlRunAutoMacro.xlAutoActivate);
}

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

Applies to