You might block closing via the "x" like this:
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = 0 Then
MsgBox "Please click OK or Cancel"
Cancel = True
End If
End Sub
--
Jim
"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:56b9d4a46da0d@uwe...
| Hi,
|
| I have a 'disclaimer' form in my application.
| I would like to:
|
| - if anything other then the "OK" button is clicked (the 'X') there
should
| be a message:
|
| "please read the disclaimer or quit (form with ok (return to 'disclaimer
| form' or quit (quit application)
|
| Does anybody have the code for this please?
| Thanks,
| Pierre
|
|
| --
| Message posted via OfficeKB.com
|
http://www.officekb.com/Uwe/Forums.a...mming/200511/1