Thread: Close Buttom
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
alvin Kuiper alvin Kuiper is offline
external usenet poster
  
Posts: 175
Default Close Buttom
Thanks
Alvin


"GerardV" skrev:

I use the userform queryclose to disable 'Red Cross'

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

--
-----------------------------



"alvin Kuiper" wrote:

Hi
In a userform there are a Red Cross to close the form
Can i disable this ?

Regards
alvin

Reply With QuoteReply With Quote