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.
Pulling on some of the techniques learnt in previous videos within our Excel VBA series, we create an Audit Trail Log that enables us to capture both the username and date / time for every user that saves our file.
Ever faced the problem where people make changes or remove crucial information (*by mistake*) which is then lost forever when they go and save the workbook?
In this tutorial we look at a simple line of VBA script that allows us to locate the last row of our data set and implement this with a copy & paste routine.