How to alert when quit excel program?

Question

Thank you in advance.

Answer 1

Put this into ThisWorkBook module of PERSONAL.XLS

Private Sub Workbook_Open()

   vbopen = Shell( "C:\myfolder\chkExcel.exe", 0) 'can change path of program but move program as well

End Sub

Download this http://www.freewebs.com/swhtam/YA/chkExc... and put it in my documents folder.

Then when excel application start this program in "myfolder" folder will start by the code above, when excel closes, it will have a pop up acknowledge termination of Excel.

Please contact for more details