I suggest Close with savechanges =False.
If you want to immediately re-open then the macro will need to be i
another workbook of course (personal.xls ?)

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