Removing the Close (X) button from UserForms 1

[mlohmac]

Hello All,

I have a seemingly simple question for you that I could not readily find in any other posts. I am using Excel 2000 and I am trying to remove the Close button (X) that appears at the top of UserForms. The reason being that I want to force the user to click an Exit command button that will execute some code.

In Access and VB you can customize the control buttons on a form. Is there any way to do this in Excel? Or If I cannot remove the button is there a way I can have it execute some code?

Thanks,
New to Excel and Frustrated
Mlohmac

 

[RobBroekhuis]

Use the userform_queryclose event to catch the close button click.
Rob

 

[rmikesmith]

Mlomhac,

Following up on Rob's reply: John Walkenbach has some code to do this on his website. Here is the url to this example

http://www.j-walk.com/ss/excel/tips/tip80.htm

Alternatively, Stephen Bullen, another Excel MVP, has a demo workbook that you can download showing how to actually remove the X close button, using the Win32 API.

http://www.bmsltd.co.uk/Excel/Default.htm

HTH
Mike

 

[mlohmac]

Thanks so much, that event is not as clearly identified as one would like. Works great however. By your reply I take it there is no way to remove the default close button?

-Mlohmac

 

[mlohmac]

Disregard my previous post, I had not read the rmikesmith's reply. Tahks again everyone.

-Mlohmac