Hello Ben,

Add this to your code...

ThisWorkbook.Saved = True

Setting this property True will suprress the "Save" message a
closing.

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=48021