On Apr 16, 8:58 am, Junior728
wrote:
Hi,

I am running a macro but it is not running smoothly due to many msg prompt
boxes appearing to ask to click "Yes","No" etc and there is also another msg
box that prompted me that there is a large amt of data from clipboard to be
copied over, and also another msg box that ask me to replace existing file,
"yes" or "no prompt.

How can i script it so that they will not appear?

Hi
Put in
Application.Displayalerts = False
'your code
Application.Displayalerts = True

regards
Paul