never heard or seen a away to have a msgbox without a ok button i
pictures and cancel buttons and what not but never without a button,
however you could write
workbook_open
userform1.show
end sub

This will display a form called sub and the forms have way more visual
appearance and conditioning that can be applied try putting this in the
code of the form and it shall work

Private Sub UserForm_Activate()
Application.Wait Now + TimeValue("00:00:10")
unload Me


End Sub



cheers


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=547494