easy with your code add the lines application.displayalerts=false (T
turn that message off) and then the same but with true (to turn tha
message back on)

*N.B REMEMBER TO TURN THEM BACK ON ELSE YOU WILL NOT RECEIVE MESSAGE
FROM EXCEL AGAIN UNTIL YOU TURN IT BACK ON!*

Hope this help

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=39014