Disabling the Windows "Close" Button (The BIG RED 'X')

**LoneWolf3574** · 10-27-2012, 02:06 AM

I'm trying to figure out how to disable the Windows environment 'X', as that is a coworkers favorite way to close Excel he sometimes loses data because of it.

I use the following coding to prevent 'improper' closure of UserForms

Please Login or Register  to view this content.

I would like to know if there is a way to disable the 'X' that does not create a mess or cause issues in general? If it helps any, we are still using Windows XP Pro ver 2002 w/ SP3 with Office 2010, but we are slowly transitioning over to Win7 Pro, ours will be the LAST location about 6 months down the road.

**BeachRock** · 10-27-2012, 02:58 AM

Take a look at this.

http://www.excelforum.com/excel-prog...se-button.html

**LoneWolf3574** · 10-27-2012, 07:33 AM

It mostly works, but the problem I run into is that when the portion of my macro that closes Excel runs, the message box pops up again, preventing Excel from closing.

The code with the popup preventing Excel from closing using the windows 'X'

Please Login or Register  to view this content.

The code saving the workbook and trying to close Excel

Please Login or Register  to view this content.

**john55** · 10-27-2012, 07:53 AM

I use a code provided by Leith Ross!
see if it helps you!

**LoneWolf3574** · 11-16-2012, 04:12 AM

I apologize for taking so long to respond on this, life in general ganged up on me real quick.

@ john55 - I couldn't get the solution you provided to work for me, maybe it's just my noobishness to VBA, I don't know.

I did find a solution that works best for me for another forums and feel that I should share in case anybody else wants to do this as well. The only real issue I have with it is that it must be activated every time the workbook is opened. So I just plug it into each module I want it in at the appropriate location and viola, it works for me.

Forum & Solution

Mind you, before the code, Sheet1 has a declaration of

Please Login or Register  to view this content.

I'm still working on my understanding of all this, but I'm pretty sure that is needed to make the macro work

Please Login or Register  to view this content.

Thank you to those who took the time to try and help me, I greatly appreciate it.

If anybody has further suggestions, please do so within the forum guidelines.