Rejje
11-19-2010, 03:34 PM
Hi!
Total vba noob need lots of :help! How do I insert a message box in the code below (macro in a button) that askes for a confirmation to either quit or prosecute?
I want the message box to say "Do you really want to quit without saving?" Then choises are buttons "Yes" or "No" in the message box..
Sub CloseNoSave()
'Close the workbook without saving it
ThisWorkbook.Close savechanges:=False
End Sub
Maybe you find a better way than to modify this code :dunno
Total vba noob need lots of :help! How do I insert a message box in the code below (macro in a button) that askes for a confirmation to either quit or prosecute?
I want the message box to say "Do you really want to quit without saving?" Then choises are buttons "Yes" or "No" in the message box..
Sub CloseNoSave()
'Close the workbook without saving it
ThisWorkbook.Close savechanges:=False
End Sub
Maybe you find a better way than to modify this code :dunno