Go into the VBA editor and on the tree on the left, click the ThisWorkbook
under the Microsoft Excel Objects and then over to the right select the
"Workbook" pulldown and then select the "BeforeClose" pulldown to the right
of that. There will now be a sub created:
Private Sub Workbook_BeforeClose(Cancel as Boolean).

Place the code there inside the Sub.