[timmulla]

I'm trying to get rid of a clip board message that comes up when my macro is
running. The pop says "large amounts of data...."

It's stopping my macro from completly automating my task.

any help would be appreciated. my email is

[Ivan F Moala[_55_]]

Put in

Application.cutcopymode=false


Before your next copy routine


--
Ivan F Moala


------------------------------------------------------------------------
Ivan F Moala's Profile: http://www.excelforum.com/member.php...fo&userid=1954
View this thread: http://www.excelforum.com/showthread...hreadid=380231

[keepITcool]

that popup shows when you close a workbook
(and have previously copied stuff)

To clear the clipboard
use application.CutCopyMode=False

You could do it prior to closing the workbook,
but maybe best to use it as soon as you're done
with copy/paste

In case you Do need the data on the clipboard,
and just dont want the message use:
Application.DisplayAlerts = False

do it just before you close the book
and set it back to True when you're done.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Timmulla wrote :

I'm trying to get rid of a clip board message that comes up when my
macro is running. The pop says "large amounts of data...."

It's stopping my macro from completly automating my task.

any help would be appreciated. my email is