Sorry please amend :
If MsgBox("Are you sure you want to do this?", vbYesNo + vbQuestion, "Please
confirm") = vbNo Then Exit Sub

Pascal

"papou" a écrit dans le message de
...
Hi Andy
If MsgBox("Are you sure you want to do this?", vbYesNo + vbsuestion,
"Please
confirm") = vbNo Then Exit Sub
MsgBox "not cancelled"
'do your stuff

To prevent closing your form add this into the form's code:
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode < 1 Then Cancel = 1
End Sub

HTH
Cordially
Pascal

"bigandyt " a écrit dans le
message de ...
i was wondering if it is possible to insert vb code in a macro that will
display to the user "are u sure u want to do this" or along those
lines, if yes the rest of the macro is executed else the macro stops.


also i want to get rid of the 'X' at the top right of my form so the
user cannot close the form is this possible

any help would be appreciated

Andy


---
Message posted from http://www.ExcelForum.com/