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

Tim,

Not disagreeing that it is a good practice, but to quote help
If you set this property to False, Micorosoft Excel sets this property to
True when the code is finished, unless you are running cross process code.

Although clearly that only takes affect at the end of the code.


--
HTH

Bob Phillips

"TimZ" wrote in message
...

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