Automatically Run an Excel Macro

Posted on the December 7th, 2008 under Workbook and Worksheet by Poer @ Excel VBA/Macro

Auto run macro excel… Do you want to run an excel macros automatically when the file is open or close?

Microsoft Excel provide us the opportunity to run a macro automatically every time we open or close the excel workbook file, using the event Workbook_Open and Workbook_BeforeClose.

In the Microsoft Visual Basic Editor page, in the ThisWorkbook module, we simply create two new sub procedure called Workbook_Open and Workbook_BeforeClose. In both sub procedure, we call the method that we want to run automatically when the workbook is open or closed.

Private Sub Workbook_Open ()

    Call onFileOpenMacro

End Sub

Private Sub Workbook_BeforeClose (Cancel As Boolean)

    Call onFileCloseMacro

End Sub

In this example, when the workbook is opened, we will automatically run macros called onFileOpenMacro, we also automatically run macros called onFileCloseMacro just before the excel workbook is closed.

Related Entries

External Resources

Microsoft Excel 2003/2007 Video Tutorials
Step-by-step video guide to mastering Charts, PivotTable, Data Analysis and Macro programming in Microsoft Excel in 5 hours.
101 Secrets of Microsoft Excel
Discover 101 of Excels little-known secrets that have been hiding right under your nose.

Tagged with: auto run macro excel

6 Responses to 'Automatically Run an Excel Macro'

RSS

January 25, 2009 at 5:47 pm
Seli

I have some code that works within one Sub, I would like to call another macro but when I tried to use call VBA wanted to set up another sub which sits outside the sub I wanted to run it in. Is there a way I can call a macro into another sub and have it run?

Geoff
January 29, 2009 at 10:43 am
Poer

Hi Seli, ofcourse we can call another macro, just use Call or directly use the function/sub name.

Also please make sure that you use public sub/function if you want it can be called from another module.
May 26, 2009 at 8:03 pm
Krish

Hi

I tried. but its not working.. i want to run the macro every time (ex: while i navigate sheet1 to sheet2).

please help.

Thanks in Advance
Krish
June 8, 2009 at 9:13 am
Poer
Halo Krish, if you need to run the macro each time an excel worksheet activated, you need to put the calling code in Sheet1 module, in event Activate like this:
```
Private Sub Worksheet_Activate()
   call onSheet1Activate
End Sub
```
August 27, 2009 at 9:41 pm
adi

Hi, I don’t understand where I’m suppose to add
the code:
Private Sub Workbook_Open ()

Call onFileOpenMacro

End Sub

In the same sheet of the macro I want to activate
but in the top???
thanks:)
September 10, 2009 at 12:58 pm
Poer @ Excel VBA/Macro

adi &rauquo; double click your VBAProject > ThisWorkbook module, as put it there or click object combo box in the right pane and select Workbook.

Excel VBA Macro