Want to run a macro before closing a workbook

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

this is possible using the VBE (ALT+F11)



In order to get this code. Within VBE, select "This Workbook From the VBAProject Panel.

On the code window you'll see a two drop down menus, one will read "(General)" click on here and select Workbook

On the adjacent menu, choose "beforeClose"

Excel will automatically put the code into the Editor for you as follows:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
'call your macro
End Sub

hth