I need to detect when a user clicks on the reb X box up in the right top
corner of the screen so I can block it from closing.
I thinkI have seen something about this some where but I just can't find it.
Any help would be a help.

oletrol

Gene;

Add this to the form's code.

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

--
Mark Rosenkrantz
---
Spreadsheet Solutions
Witkopeend 24
1423 SN
Uithoorn, Netherlands
---
E:
W: www.rosenkrantz.nl


"Gene Mills" wrote in message
. ..
I need to detect when a user clicks on the reb X box up in the right top
corner of the screen so I can block it from closing.
I thinkI have seen something about this some where but I just can't find
it.
Any help would be a help.

oletrol