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.