Running a macro in excel 2013 every time workbook opens or closes

Question

I want to run a macro every time an excel files opens and before it closes. I've tried using the below script but it didn't work.

Private Sub Worksheet_Activate()
'my macro
End Sub

Answer 1

How do I run a macro every time a workbook opens or closes?

Opens:

Private Sub Workbook_Open()
' dosomething
End Sub 

or

• Use Sub Auto_Open() in a module

---

Closes:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
' dosomething
End Sub 

or

• Use Sub Auto_Close() in a module

---

Sources:

• StackOveflow question what is a good way to autorun macros upon open
• VBA code to run a macro prior to closing an excel file