Need Help changing how the excel window closes to use a macro instead (the red X)

I've been looking around trying to figure out how to change what happens when the X in the Excel window is clicked. So far I've found the coding for disabling the X, but this isn't what I really would like to do. I'm trying to make it so that when it is clicked/selected that a macro I generated to close save the workbook and close excel is run instead. Any help, even pointing me toward a resource, would be appreciated. Thanks in advance