Excel VBA - Run Macro When User Closes Workbook!

by Ben Thompson

Continuing our look at change events I wanted to complete the cycle by including this look at how to trigger a macro to run each time a workbook is closed.

This functionality can provide a number of features such as tracking users or ensuring structures/ formatting is enforced to name a couple.

 

Access our COMPLETE Excel Course HERE

VBA Playlist ► https://essentialexceluk.com/blogs/tutorials/tagged/vba

More Tutorials ► https://essentialexceluk.com/blogs/tutorials

Back to Tutorials