How To Trigger A Macro Before Window Close?

[cnewtonne]

Hi all,

I have a need to run a macro before a window is closed that does few safety checks. This macro needs to run regardless of how the user opted to close the windows (mouse, alt+F4, etc).

Can this be done? If not, any tricks that can be used to accomplish it?

[Cory]

I can't think of anything. I mean if you want to activate the macro to run automatically it would be kind of hard to do that without some sort of event. IOW until ME can read minds how would it know the users intent. I think you would need to have the user activate with a hotkey or something since you can’t intercept a mouse click on the close button. Maybe if there was some dialog box that popped up you could activate off a control in there. For instance if a confirmation screen like “Are you sure you want to save your changes?” pops up when they go to close you could use that but otherwise I think you will need to have the user activate.