Thread: Disable close button on all froms & MsgBoxes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
MSweetG222 MSweetG222 is offline
external usenet poster
  
Posts: 158
Default Disable close button on all froms & MsgBoxes
On user forms try...

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
Cancel = True
'Chg msg text to fit your needs...
MsgBox "Please use the ''OK'' Button.", vbInformation
End If
End Sub


--
Thx
MSweetG222



"Haxer" wrote:

Is there a way to disable/hide/something the close buttons in all userforms
and msgboxes in a workbook? If not can you individually disable/hide them in
userforms? MsgBoxes?
Reply With QuoteReply With Quote