Remove close button from Userform

[jpen]

Hi all,

I have made a userform which works. But the only problem I have is the in the right upper corner of the userform is a close button. Is there a way to remove this button.

Thanks,

JH

 

[Andrew Poulsom]

I don't know about removing it, but it's easy to disable it:

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

 

[Mudface]

There's also a download on Stephen Bullen's site called FormFun which allows you to remove the close button etc-

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

 

[jpen]

Thanks,

I just the solution of Walker. Then next problem if have is that I made a button on the form for maintenance of the program. When I run the I want the close button to be operational.

Any ideas.

JH

 

[Mudface]

Just put code in the click event of the button to close the form. The QueryClose event from JWalk will only prevent the closing of the form via the 'X' button.

 

[jpen]

Thanks both it works great.

JH