Run a macro when a user exits the application

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If there a way to put in code that when a user closes out of the application
to automatically run a macro

Thanks
 
John,

There is no specific event for the application closing. How does the
user close the application? Do they click on a button on a form? If
so, you could attach your macro to the On Click event property of this
button, prior to the Quit action. Or, if this is a form which is always
open whenever the application is open, you could use the On Unload event
property of the form.
 
Back
Top