Disable Close X on workfile

[mwc0914]

I have a module in my workbook that builds a new xlsx workfile from data read in other files.
After building the workfile, the module displays a userform with a button (modeless so the user can update the data in the new workfile).
When the user is through updating the workfile, I want to force them to click the button on the userform to save & close the workfile.
I do not want to allow the user to close the workfile by clicking on the X on the workfile.
How can I associate a beforeclose method to the new workfile, to prevent the usage of the X to close the workfile?
Also, when the userform button is pressed, the workfile should save & close.

 

[BobUmlas]

Have it build a new xlsm instead of xlsx -- actually have a template which the macro opens and uses, and this template (xlxm) has the BeforeClose Event already in it:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
MsgBox "Please close via the userform button!"
End Sub

 

[mwc0914]

Tried that. When the userform is clicked, it activates the beforeclose method on the workbook & it thinks the closemode = 0, and it throws the msgbox. When clicking on the userform button, it should close.

 

[Jaafar Tribak]

@mwc0914

Please do not post twice the same question