| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Large amount of info on the clipboard
Hi everybody, My macro program involves moving large amount of info from one sheet to another. I keep getting the message that "There is a large amount of information on the Clipboard..." and is giving me the option to save it or delete those info. I don't need those info anymore so I just click on "No". Is there a way to disable this message via macro or setting in Excel/Windows? -- ledzepe ------------------------------------------------------------------------ ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207 View this thread: http://www.excelforum.com/showthread...hreadid=518028 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Large amount of info on the clipboard
ledzepe
Application.DisplayAlerts = False ' your code Application.DisplayAlerts = True Regards True "ledzepe" wrote in message ... Hi everybody, My macro program involves moving large amount of info from one sheet to another. I keep getting the message that "There is a large amount of information on the Clipboard..." and is giving me the option to save it or delete those info. I don't need those info anymore so I just click on "No". Is there a way to disable this message via macro or setting in Excel/Windows? -- ledzepe ------------------------------------------------------------------------ ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207 View this thread: http://www.excelforum.com/showthread...hreadid=518028 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Large amount of info on the clipboard
Application.cutcopymode=false
is another way. ledzepe wrote: Hi everybody, My macro program involves moving large amount of info from one sheet to another. I keep getting the message that "There is a large amount of information on the Clipboard..." and is giving me the option to save it or delete those info. I don't need those info anymore so I just click on "No". Is there a way to disable this message via macro or setting in Excel/Windows? -- ledzepe ------------------------------------------------------------------------ ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207 View this thread: http://www.excelforum.com/showthread...hreadid=518028 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I paste a large amount of text into a cell ? | Excel Discussion (Misc queries) | |||
| Excel - give users option to keep info in clipboard after pasting | Excel Discussion (Misc queries) | |||
| SELECT large amount of data in a worksheet | Excel Discussion (Misc queries) | |||
| Fit large amount of text in 1 cell | Excel Discussion (Misc queries) | |||
| large text amount in cell will not display in the cell | Excel Discussion (Misc queries) | |||
Linear Mode
