Disable excel's "Close" button (red X) in workbook for more than 1 click

Hi YasserKhalil

It unfortunately still only works for the first click. I have seen similar reply to the one you gave elsewhere and it didn't work either.

Any other suggestions?

Thanks

When I say the "first click" I mean that when I go and click close in the top right hand corner for the first time I get the message box pop up as expected. If I click ok on the message box and then go and try close the workbook again it then closes like it normally would. I don't get the message box appear again. So it only ever functions correctly for the first iteration and then it no longer works and I can close the workbook as usual with the close button in the top right hand corner.

I have assigned your CloseMe sub to a button which does close the workbook.
Is it possible to post a video so i can show you how?

Regards

On my machine your file does the same thing for me as my code and only works on the first attempt. After that it closes as normal. Do you know of any settings that may need to be changed to prevent this happening because it must be something other than the macro.

I am also using 2016.

I tried it out after remote desktopping in to a server running excel 2010 and it worked correctly there. I also tried it through VDI in to another portal running 2016 and it only worked for 1 click there.

So something is strange.

Im using a surface pro laptop

I can't replicate this. Would an alternative be to allow the BeforeClose event to share whatever actions the button performs?

Hi ByteMarks

Even writting the code as a stand alone and not attached to any button doesnt work. Ive checked the code on other computers and they are all fine. It is the surface pro that seems to be the issue which others seem to have noted on other forums.

Regards