Thanks Tom Ogilvy & Sharad Naik

Actually the DoEvent i did tested it before, but not working for me.

and the function ".Refresh BackGroundQuery:=False" which coming up wit
error in every first time to hit, the message display as "The proces
already running at the back end".

:confused

--
Louis LA
-----------------------------------------------------------------------
Louis LAI's Profile: http://www.excelforum.com/member.php...fo&userid=1562
View this thread: http://www.excelforum.com/showthread.php?threadid=27174