Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display "macro-free workbooks - VB project message" on closing Exc | Excel Discussion (Misc queries) | |||
How to disable "There is a large amount of data on the clipboard..." | Excel Discussion (Misc queries) | |||
Help with handling large amounts of data - determine "MIN IF" ? | Excel Worksheet Functions | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
Utility to "clean up" or "defrag" large Excel file | Excel Discussion (Misc queries) |