NoCloseButton.zip about 2/3rds down the page or perhape this code would help
(placed on your userform -

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)

' Prevents use of a Close/Cancel button
If CloseMode = vbFormControlMenu Then
MsgBox "Please select the CANCEL button.", , ""
Cancel = True
End If

End Sub


"bigwheel" wrote:

Hi, take a look he- http://www.oaltd.co.uk/Excel/

"ceemo" wrote:


Hi,

Ive created a password form that activates on workbook open and i want
to disble the red cross in the top right corner of the form or change
the code to disble the form.

can this be done, please help


thank you all as always for your help


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=475594