PDA

View Full Version : Solved: Prompt before Exit



softman
10-04-2010, 07:47 AM
Hi,

I have a VBA code not to save the work book on exit. I am looking for some help on a message box that also ask "Are you sure you want to exit". Yes No...

Many thanks in advance.

Bob Phillips
10-04-2010, 07:57 AM
If MsgBox("Are you sure you want to exit", vbYesNo, "Workbook Save") = vbNo Then

'your code
End If

softman
10-04-2010, 10:29 PM
If MsgBox("Are you sure you want to exit", vbYesNo, "Workbook Save") = vbNo Then

'your code
End If


Thanks XLd