If you use Application.DisplayAlerts = False, don't forget to follow the
code with:

Application.DisplayAlerts = True

Otherwise, Excel will not prompt you to save changes when you close a
worksheet - something that many users rely on.

Tim


--
TimZ
------------------------------------------------------------------------
TimZ's Profile: http://www.excelforum.com/member.php...o&userid=23558
View this thread: http://www.excelforum.com/showthread...hreadid=375545