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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RunCommand - Exit 1
VB Macro Command to close MS Access application 1
Excel Providing user message when RED X clicked & properly closing application. 2
Macro to change Yes/No checkbox to No when exiting record 5
Run a macro after a table is updated.... 3
Run Macro If Cell have "x" value 0
Closing an application in a macro. 1
macro when access closes 1

Back
Top