I want to be able to offer a choice of saving or not before closing a workbook & quitting Excel when the user presses either of the x's on the workbook or application.
I have tried several ways but just can't get it to work!
Currently I have...
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.ScreenUpdating = False
ResetToStandardMenus
Application.Quit
End Sub
Any ideas please
I have tried several ways but just can't get it to work!
Currently I have...
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.ScreenUpdating = False
ResetToStandardMenus
Application.Quit
End Sub
Any ideas please