How to trigger macro on closing of model window

I am trying to develop a macro, that should be triggered automatically on clicking the close button of a model window.

Our ultimate aim is to check whether the particular template is applied on the model or not. Each time when we close the model then the macro should trigger automatically and it should give a dialog message box which says do you want to apply template now. if we click on OK button then required template should be applied.