| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Message Box on exiting workbook
Hi,
maybe this Private Sub Workbook_BeforeClose(Cancel As Boolean) response = MsgBox("Are you sure you want to quit?", vbYesNo) If response = vbNo Then Cancel = True End If End Sub Mike "cufc1210" wrote: I have a spreadsheet where i have a macro that saves and exits the workbook. when the save & Exit button is pressed is it possible to have a message box pop up and ask if they are sure they want to exit the workbook. Then when they select ok it will continue to save and exit. I hope this makes sense |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| exiting excel ONLY the workbook will close | Excel Discussion (Misc queries) | |||
| Pop-up Message for each worksheet in a workbook | Excel Discussion (Misc queries) | |||
| Re-establish function on exiting workbook | Excel Worksheet Functions | |||
| how do i get a pop up message on saving or exiting a document? | Excel Worksheet Functions | |||
| Can I add a pop-up message that will show when a workbook opens | Excel Discussion (Misc queries) | |||
Threaded Mode
