How to disable "X" for closing workbook and force use of button

I need to be able to force users to click a button to close the workbook and not the "X" in top right corner.

Each user has their own copy of the workbook and it saves to a central location but only when they use the "Exit" button. If they close it via the "X" then a Macro to save the work doesn't run.

I need to be able to disable the use of the "X" and prompt the user to close via the exit button. I've read about how to do it when using userforms but this doesn't seem to do the job.

Any help please?



PS. sorry if this has been posted before but I couldn't find anything relating to my issue.

I've created a button to exit the workbook and perform the necessary functions, I just need to stop using the "X" in the top corner or the file exit menu option as if they then decice to save the file it will overwrite the original

Putting this:

Please Login or Register  to view this content.

In your ThisWorkbook object in the vba project will effectively disable the X button. However, you will need to change your button macro to disable events before trying to close the workbook that way also. Alternatively you can change the X button to run your close routine using something like:

Please Login or Register  to view this content.

You will still need to disable events to close your workbook from a macro.

Perfect. Thanks for the help

I tried using this code but have run into a problem. If the user clicks on the close button the code works fine. If the user clicks a second time the code does not work and the user gets the usual Save, Don't Save, or Cancel window from Excel. How can the Close "X" be permanently disabled?

Thank you.

Thank you for your reply. I just tried the code and it still allows the user to exit using the close "X" button on the second try. Events have not been disabled.
Any ideas?

Thank you for your reply. I just tried the code and it still allows the user to exit using the close "X" button on the second try. Events have not been disabled.
Any ideas?