![]() |
|
|
|||
|
Pop up Reminder dialog boxes in Excel
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. |
|
|||
|
Re: Pop up Reminder dialog boxes in Excel
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. |
![]() |
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|