Udostępnij za pośrednictwem


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

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

See Also

Reference

WorkbookBase Class

Microsoft.Office.Tools.Excel Namespace