Hi Celtic

You can use this event in the userform module

Private Sub UserForm_QueryClose(Cancel As Integer, _
CloseMode As Integer)
If CloseMode < vbFormCode Then
MsgBox "Use the Close button to close the form.", _
vbOKOnly, "yourprogramname"
Cancel = True
End If
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Celtic_Avenger" wrote in message ...

Hope someone can help.

I have created a userform as a navigation menu for a very large
spreadsheet.
This Userform is sized to full screen, and all control buttons on the
User form lead to other full screen User forms.
The spreadsheet sheets simply operate and collate information entered
into the User forms in the background.

To ensure that the Userforms cannot be closed to give easy visible
access to the spreadsheet below, I would like to be able to disable the
"X" close button on the user form.

Is this possible.

Thanks for any help you can give.

Celtic_Avenger


--
Celtic_Avenger
------------------------------------------------------------------------
Celtic_Avenger's Profile: http://www.excelforum.com/member.php...o&userid=14101
View this thread: http://www.excelforum.com/showthread...hreadid=268222