I have macro that copies some data from a workbook and then tries to close
it. I want it to run without stopping, but I get the message that there is a
large amount of data in the clipboard - and I need to click "OK". Is there a
way to suppress that message so the macro will complete? Thanks.

You might like to add this to your macro before closing the workbook:

Application.DisplayAlerts = False

This will suppress the error message. Then turn it back on again with
this:

Application.DisplayAlerts = True

Hope this helps.

Pete

On Nov 12, 1:09*am, dhstein wrote:
I have macro that copies some data from a workbook and then tries to close
it. *I want it to run without stopping, but I get the message that there is a
large amount of data in the clipboard - and I need to click "OK". *Is there a
way to suppress that message so the macro will complete? *Thanks.

hi
add this to the begining of your code...
Application.DisplayAlerts = false

this will turn off all of excel's built in error messages.

but...".big word"....be sure to turn them back on at the end of your code...
very unwise not to..........
Application.DisplayAlerts = TRUE

regards
FSt1



"dhstein" wrote:

I have macro that copies some data from a workbook and then tries to close
it. I want it to run without stopping, but I get the message that there is a
large amount of data in the clipboard - and I need to click "OK". Is there a
way to suppress that message so the macro will complete? Thanks.

Before closing the file, execute the following statement:

Application.CutCopyMode = False

If the problem still continues, which it may, copy a single cell. This will
make the contents of the clipboard very small and thus eliminate the
message.

Robert Flanagan
Add-ins.com LLC
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, fax 302-234-9859
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"dhstein" wrote in message
...
I have macro that copies some data from a workbook and then tries to close
it. I want it to run without stopping, but I get the message that there
is a
large amount of data in the clipboard - and I need to click "OK". Is
there a
way to suppress that message so the macro will complete? Thanks.

Thanks for the information - it worked great

"FSt1" wrote:

hi
add this to the begining of your code...
Application.DisplayAlerts = false

this will turn off all of excel's built in error messages.

but...".big word"....be sure to turn them back on at the end of your code...
very unwise not to..........
Application.DisplayAlerts = TRUE

regards
FSt1



"dhstein" wrote:

I have macro that copies some data from a workbook and then tries to close
it. I want it to run without stopping, but I get the message that there is a
large amount of data in the clipboard - and I need to click "OK". Is there a
way to suppress that message so the macro will complete? Thanks.