Gary, you could try
Application.DisplayAlerts = False
'Your Code that is making the prompt come up
Application.DisplayAlerts = True


--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"gary" wrote in message
...
Does anyone have a snipit of code that will respond to the
clipboard prompt...
"There is a large amount of information on the clipboard.
Do you want to ..."
Thanks, Regards,
Gary