View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim[_39_] Tim[_39_] is offline
external usenet poster
 
Posts: 71
Default DISABLE CLOSE MSGBOX ON CLICK "X"


"sal21" wrote in message
...

How to disable the close option with "X" in a msgbox?


the following works for a userform... not sure if it would work for a
msgbox: -

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

hth,

tim