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

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
.

Using the queryclose event would be easier.

--
Regards,
Tom Ogilvy


"Kevin" wrote in 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