disable close only use command button

[pejabe]

I'm trying to stop the workbook from closing using the X or file close option
I would like them only to use the command button
but when I click the close button it prompts with the save dialog box yesnocancel, I do not want
this is the code I'm using in the this workbook

Please Login or Register  to view this content.

I have tried this

Please Login or Register  to view this content.

but still shows this

save.jpg


any help would be good

[kasan]

This should work:

Please Login or Register  to view this content.

This code must be pasted in ThisWorkbook

[pejabe]

that's what I'm using but doesn't work