RunAutoMacros Method

Workbook.RunAutoMacros Method

Office 2007
Runs the Auto_Open, Auto_Close, Auto_Activate, or Auto_Deactivate macro attached to the workbook. This method is included for backward compatibility. For new Visual Basic code, you should use the Open, Close, Activate and Deactivate events instead of these macros.

Syntax

expression.RunAutoMacros(Which)

expression   A variable that represents a Workbook object.

Parameters

NameRequired/OptionalData TypeDescription
WhichRequiredXlRunAutoMacroSpecifies the automatic macro to run.

Remarks

XlRunAutoMacro can be one of these XlRunAutoMacro constants.
xlAutoActivate. Auto_Activate macros
xlAutoClose. Auto_Close macros
xlAutoDeactivate. Auto_Deactivate macros
xlAutoOpen. Auto_Open macros

Example

This example opens the workbook Analysis.xls and then runs its Auto_Open macro.

Visual Basic for Applications
Workbooks.Open "ANALYSIS.XLS"
ActiveWorkbook.RunAutoMacros xlAutoOpen

This example runs the Auto_Close macro for the active workbook and then closes the workbook.

Visual Basic for Applications
With ActiveWorkbook
    .RunAutoMacros xlAutoClose
    .Close
End With



Show:
© 2016 Microsoft