Workbook.RunAutoMacros method (Excel)

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.


expression.RunAutoMacros (Which)

expression A variable that represents a Workbook object.


Name Required/Optional Data type Description
Which Required XlRunAutoMacro Specifies the automatic macro to run.


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


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

Workbooks.Open "ANALYSIS.XLS" 
ActiveWorkbook.RunAutoMacros xlAutoOpen

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

With ActiveWorkbook 
 .RunAutoMacros xlAutoClose 
End With

See also

Workbook Object

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.