Remove Close Button From Excel Form 2

[DYM03]

I cannot find the property setting, if there is one, to remove the close button from the User Form in Excel. I have been looking for the code to do this but I can't find it. Any help or suggesstions would be appreciated. I also tried importing a form I created in Access but that is not working for me to well either.

 

[acron]

You can disable the button with th e following code :

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    If CloseMode = 0 Then Cancel = True
End Sub

To actually remove the button (x) would require some API calls.

A.C.

 

[Chattin]

This do?

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

HTH

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help

 

[DYM03]

Thanks to both of you. That worked great.