Workbook Event BeforeSave to Prompts the User for his Response to really Save the Workbook or Not.
The following example prompts the user for a YES or NO response before saving any workbook.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Alert = MsgBox("Press Yes to Save the Workbook", vbYesNo, "Do You Really Wants to Save ?")
If Alert = vbNo Then Cancel = True
BeforeSave Event Image View :
Prompt for the User :
Each time when you press "Ctrl+S" , the Event will occur and Prompt the Msgbox for User Response as below: