Additionally, I think that DisplayAlerts = false will choose the default
setting of the window that normally would pop up. I have used this before,
but thought there was some caveat about trying to get the thing to do what I
wanted it to do, because the default answer was No or something like that....
Hmmm.. I think nicky is right though, at least that option must be
implemented.

"nickysquawkes" wrote:


I think you need to turn the display alerts off using the following:

Application.DisplayAlerts = False

Nick


--
nickysquawkes
------------------------------------------------------------------------
nickysquawkes's Profile: http://www.excelforum.com/member.php...o&userid=30630
View this thread: http://www.excelforum.com/showthread...hreadid=502834