Does anyone know how to create these in excel? I have a spreadsheet that
when I go to close the application I want it to pop up an information box to
remind me to do a task and even open the application that is needed to be
performed.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox "Don't forget to do something"
If Not ThisWorkbook.Saved = True Then
ThisWorkbook.Save
End If

Code to open another workbook or start another application

End Sub

Right-click on the Excel icon left of "File"

Select "View Code" and paste the above into that module.

Alt + q to return to the Excel window.

Close the workbook.


Gord Dibben MS Excel MVP


On Thu, 24 Jul 2008 06:51:01 -0700, tannerdude
<tannerdude@discussions.microsoft.com> wrote:

>Does anyone know how to create these in excel? I have a spreadsheet that
>when I go to close the application I want it to pop up an information box to
>remind me to do a task and even open the application that is needed to be
>performed.