I have been looking for a way in VBA to get a notification of the file that a user just closed or is trying to close (similar to how when you try to close an unsaved file and are asked if you would like to save the file). I was thinking that FileCloseNotify would work but sadly it seems that only works if you call closeandreopen which I am not. I have been working on this all day and not much to show for it so a point in the right direction would be great!

Thanks,

David