create copy file when closing excel in VBA

Hi,
I'm very new to VBA. I was able to find help in making a macro, and linking a button, to make a copy of my file on a different drive.
Is it possible to do this when I close do have functionality when I close excel?

Here is my code:
Sub Backup_Files()
ActiveWorkbook.SaveCopyAs "D:\Time Sheets\BackUp_" + ActiveWorkbook.Name
End Sub

Here's a copy of my file. My code is in Module4

I've been able to figure out my issue.
I appreciate your time if you've looked into this.

Would you mind posting your solution? Looking into doing the same thing, but haven't figured it out yet .
Thanks

Hi,

just using the workbook event BeforeClose …

thank you very much