Application.cutcopymode = False

executed before closing the workbook will avoid the message.

You can also do

application.Displayalerts = False
' close the workbook
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy


"ppyxl" wrote:


Hi, guys,

I do not want to see the pop up windows saying----there r lots of
information on the clipboard. Do you want to be able to paste this into
another program later (Yes or No or Cancel) -

is there code for stoping them from poping up ??? Thanks!


--
ppyxl
------------------------------------------------------------------------
ppyxl's Profile: http://www.excelforum.com/member.php...o&userid=36116
View this thread: http://www.excelforum.com/showthread...hreadid=562862