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

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

It works in excel. thanks!

* D o y o u k n o w i n a c c e s s , h o w t o c l o s
e p o p u p w i n d o w s a s w e l l ? *

Thanks


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

* D o y o u k n o w i n a c c e s s , h o w t o c l o s
e p o p u p w i n d o w s a s w e l l ? *



in access VBA you would use 'DoCmd.SetWarnings (False)'

how does vba use in access

--
ppyx
-----------------------------------------------------------------------
ppyxl's Profile: http://www.excelforum.com/member.php...fo&userid=3611
View this thread: http://www.excelforum.com/showthread.php?threadid=56286