Prompting user before saving
 

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