View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 292
Default disable the x button on a userform

Hi

Disable:

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

I think Hide is a part of FormFun. It's far more complex:
http://www.oaltd.co.uk/Excel/Default.htm

HTH. Best wishes Harald

skrev i melding
oups.com...
Hi all,

How can I disable the X (close button) on a userform, or hide it all
together

manythanks

Johny5