put this in your code

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode A
Integer)
Cancel = 1
End Sub

this will stop the user from closing the userform

Phonio:cool

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