Hi Andy

Sub Dothings()
MsgBox "I work"
If MsgBox("Continue ?", vbYesNo + vbQuestion) = vbNo _
Then Exit Sub
MsgBox "Still working"
End Sub

As for the form X, is it userform. Will disabling it do ?
http://j-walk.com/ss/excel/tips/tip80.htm
If not it needs some quite heavy windows techniques, see FormFun at
http://www.bmsltd.ie/Excel/Default.htm

HTH. Best wishes Harald

"bigandyt " skrev i melding
...
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/