Capture "cancel" on Standard Menu " close "

[donwb]

Windows 10 running Excel 2003.

I need to capture the cancel event when the "Cancel" button on the standard Menu/Close form is pressed.

I'm using Menu/Close to exit a workbook (which contains VBA code) , and the "Yes" and "No" buttons work fine.
However, the "Cancel" button isn't taking me back to the workbook's condition prevailing before it was pressed.

So I need to capture it's event to see where it actually occurs in my code.

Web trawls have produced nothing of use.

[Logit]

.
Not certain I fully understand what it is you are requesting. Seeing your code would help greatly.

Normally, when the user clicks on CANCEL, the code would include an "EXIT SUB" command. And, if necessary,
clear any fields filled in prior to that point.

[donwb]

Have now solved the problem by rearranging and re-locating some lined of code.
Thanks for the inputs.

[sdjvar]

You can try to put this in your macro to stop the cancel key.

Application.OnKey "{ESC}", "" ' to disable Esc key