How do I refer to an event and create a function for the event of another workbook?

I have a AddInWorkbook.xla that works as a add in and it needs to refer to whatever new workbook that the user opens. I need the new workbook to tell the AddInWorkbook.xla when the new workbook's closing event is dispatched.

So it is possible to do something like this in VBA Excel?

Or otherwise like adding a event listener to it? Possible?
PHP Code:
//inside AddInWorkbook.xla
ActiveWorkbook.addEventListener("Workbook_Close"closeHandler)
function 
closeHandler(Event e) {
   if 
e.filename == ActiveWorkbook.filename {
      
//then from here I can carry on...
   
}