I want to run a macro before I close a workbook. This is because sometimes I forget to run the macro which causes my data to not be updated.

Before the command for workbook close is executed, the macro is run

Is it possible to do this?

Thanks for your help