I need to interrogate the result of the prompt that displays after the BeforeClose event runs.
This is the message box that displays currently:
Microsoft Excel
Do you want to save the changes you made to 'FILENAME'?
YES NO CANCEL
If the user clicks CANCEL, I need to make sure some code I have does NOT execute.
Any suggestions? Is there a "CLOSING" event that I am not aware of that I can use to capture the result of this message?
Thank you.
This is the message box that displays currently:
Microsoft Excel
Do you want to save the changes you made to 'FILENAME'?
YES NO CANCEL
If the user clicks CANCEL, I need to make sure some code I have does NOT execute.
Any suggestions? Is there a "CLOSING" event that I am not aware of that I can use to capture the result of this message?
Thank you.