| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macros
I am running a macrom that includes a number of copies and pastes of large
amounts of data. I keep getting the message about there being a large amount of data on the clipboard. Do I want to keep it. After clicking No the, macro proceeds. How do I either prevent this message from popping up? or automatically answer it 'No' TIA Sanford |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macros
Hi,
Application.displayalerts=false your code Application.displayalerts=true Mike "Sanford Lefkowitz" wrote: I am running a macrom that includes a number of copies and pastes of large amounts of data. I keep getting the message about there being a large amount of data on the clipboard. Do I want to keep it. After clicking No the, macro proceeds. How do I either prevent this message from popping up? or automatically answer it 'No' TIA Sanford |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macros
After the copy and paste add this line to clear the clipboard.
Application.CutCopyMode = False Gord Dibben MS Excel MVP On Tue, 3 Nov 2009 07:42:01 -0800, Sanford Lefkowitz wrote: I am running a macrom that includes a number of copies and pastes of large amounts of data. I keep getting the message about there being a large amount of data on the clipboard. Do I want to keep it. After clicking No the, macro proceeds. How do I either prevent this message from popping up? or automatically answer it 'No' TIA Sanford |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macros
The following code will clear the clipboard
Application.CutCopyMode = False "Sanford Lefkowitz" wrote: I am running a macrom that includes a number of copies and pastes of large amounts of data. I keep getting the message about there being a large amount of data on the clipboard. Do I want to keep it. After clicking No the, macro proceeds. How do I either prevent this message from popping up? or automatically answer it 'No' TIA Sanford |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros: can you copy macros from one doc to another? | Excel Discussion (Misc queries) | |||
| Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
| Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
| Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
| Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
Linear Mode
