Adding Code To The Action of A Userform Red Corner X

I have an open userform. I don't want it's users to exit the form by instinctively clicking the red top right corner X (I do have a preferred exit button) as this, combined with closing the workbook itself incorrectly may result in data loss.\

I was hoping I could use code to purpose it's function to save the workbook before closing the form, that way the workbook will be saved on closing the userform accidently by the red X.

Here is the code I researched but I can't seem to get it to work. The code is never triggered to be executed.

Please Login or Register  to view this content.

Alternatively, you could disable the X like

Please Login or Register  to view this content.

Have you tried the before close event??

Hi nigelog ... I'm sorry, I don't understand your solution. I am using the before_close event, but the problem arises when I run code to close (with saving) that workbook with the before_close event associated to it.

Untested, but try

Please Login or Register  to view this content.

Thank you so much Fluff, that worked very well. I did notice though the

Please Login or Register  to view this content.

lines aren't executed (for obvious reasons). This won't affect Excel in general will it? It's kind odd to see excel as just one blank grey canvas (no blank or other worksheet).