Welcome to FreeSoftwareServers Confluence Wiki
Make sure to place this under "ThisWorkbook", not separate "Module" & under "Open"
Private Sub Workbook_Open()
MsgBox "WorkBook Open"
Private Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox "WorkBook Close"
This site is just a Tech Blog, nothing is guaranteed!