Hi Kevin:

Can't you just transfer the code behind your command
button to the form's terminate event?

gareth

-----Original Message-----
I am developing an application in excel that uses a form
for data entry. I would like to hide (if possible) the x
at the top right to prevent the user from closing the
form
unless they do it through a button I have created. I need
to be able to control how they get out of the form so I
can set certain properties, etc in the application.

Any help would be greatly appreciated!

Kevin
.