Automatically run macro upon opening every Excel workbook

Question

Using a Personal workbook with macros, how do I make it so a macro runs as soon as you open any workbook? I've found not-quite-solutions to this (code is below), but it doesn't do what I need because it only works when you open Excel for the first time. I want to be able to keep Excel open, and any new workbooks that are opened will trigger a macro to run.

Sub workbook_open() 
MsgBox ("Hello.")
End Sub

You can use a button to let the user select the workbook which the user want's to open. This will be way better than running code on opening ANY workbook (if that's even possible). — nvkrj
Possible duplicate - stackoverflow.com/questions/31615594/… — Rdster

BruceWayne BruceWayne · Accepted Answer · 2016-11-07T19:53:49

You want to use the Workbook Open event. Please this in a workbook module:

Private Sub Workbook_Open() 
 Msgbox("Hello.")
 ' Whatever other code you like here too.
End Sub

Automatically run macro upon opening every Excel workbook

1 Answers