Automatically Run an Excel 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.

Posts Related to Automatically Run an Excel Macro

Schedules to Refresh Data Automatically using VBA Macro
I once asked by Joshuacht about how to make a macro running every 15 minutes. Let say because every 15 minutes we have to refresh ...
How To Open Excel File Using Macro
Imagine this condition; We are in the middle of doing something using Excel VBA macro, then we want the macro to automatically show the File ...
Check If Excel Workbook is Already Open or Not
In my case, I work a lot with transferring data from current Excel Workbook to another Excel Workbook, and to be able to do that, ...
Changing Microsoft Excel Status Bar
Maybe for some reason we want to change our Microsoft Excel Status Bar, then this simple vba function will do the work for us. The ...
Automatically Protect/UnProtect All Worksheets
Tonight I want to automatically protect and unprotect all Microsoft Excel Worksheets in my Workbook with password, instead of doing it manually, I put these ...

18 Responses to Automatically Run an Excel Macro

Seli says:

January 25, 2009 at 5:47 pm

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
Poer says:

January 29, 2009 at 10:43 am

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.
Krish says:

May 26, 2009 at 8:03 pm

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
Poer says:

June 8, 2009 at 9:13 am
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
```
adi says:

August 27, 2009 at 9:41 pm

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:)
Poer @ Excel VBA/Macro says:

September 10, 2009 at 12:58 pm

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

April 6, 2010 at 6:59 pm

Its not working?

Public Sub Workbook_Open()

Call onFileOpenMacro

End Sub

Public Sub onFileOpenMacro()
MsgBox (“yo”)
End Sub
Ajit says:

April 13, 2010 at 12:43 pm

hi,
i want’s to create an excel file where if i key in a serial number in the cell, the file will automaticaal come and attach to the cell. I dont want to go for Hyperlink.
Any suggestions or help pls.
Ajit
Suresh Kumar says:

October 26, 2010 at 7:31 pm

hi dears,

I need to run a macro when ever i open excel file.

Tha above procedure i have tried it is not working.
Could you please tell me step by step
Jordan Jubilo says:

November 26, 2010 at 9:29 pm

Its not working?

Public Sub Workbook_Open()

Call onFileOpenMacro

End Sub
Pingback: reverse mortgages
Pingback: information about reverse mortgages
Pingback: cruises from new york
Pingback: acid reflux symptoms
Pingback: Bill Maher Tour Dates
Pingback: Bill Maher Tour Dates
Pingback: kohler tubs
Pingback: courts furniture