Thread: Red X close box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Spreadsheet Solutions Spreadsheet Solutions is offline
external usenet poster
 
Posts: 33
Default Red X close box

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