xOut

[Kevin]

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

 

[Guest]

Hi Kevin:

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

gareth

 

[Tom Ogilvy]

Using the queryclose event would be easier.