VBA: Run a macro when Excel closes

August 14th, 2004 | Categories: VBA | Tags: close, macro, VBA

-->

Do you need to run a macro when Excel closes? You can use the Auto_Close sub.

1. Simply create a subroutine called Auto_Close and place code in it, or call another sub from there. Automatically your code runs when Excel closes.

Private Sub auto_close()

MsgBox "This code ran at Excel close!"

End Sub

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!