Well it seems quite straight forward as you dont want to allow the use
another option other than ok but i suggest you use Msgbox Msgentr
"YOUR TEXT",vbokcancel,"TITLE OF BOX HERE" stick it all in a
auto_close and add the line ThisWorkbook.Close savechanges:=True (thi
closes the workbook that is running the code)
Of course you will have to specify what either ok or cancel will d
when clicked i.e if msgbox=6 then blah!
HTH
Simo
--
Message posted from
http://www.ExcelForum.com