Thread: How to disable the Exit Button of UserForm in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
William[_2_] William[_2_] is offline
external usenet poster
  
Posts: 227
Default How to disable the Exit Button of UserForm in Excel?
Hi Alex

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


--
XL2002
Regards

William



"Alex" wrote in message
...
| How to disable the Exit Button of UserForm in Excel?


Reply With QuoteReply With Quote