Hi,

how will workbook_close work with application.enableevents = false?

Maybe a clear solution is to go through your code and make sure that
you disable events when you need them disabled and enable them
immediately when possible. Otherwise you may experience "strange"
behaviour with events not firing when they should.

The benefit from this for you is much clearer code and that you can use
worksheet_change event.

Regards,
Ivan