| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste and clipboard contents message
I am copying and pasting data using a macro. After the data is successfully
copied and pasted i get a message: Large amounts of data are on the clipboard do you want to be able to paste this data into a program later? yes no cancel. Can i just clear the clipboard in my macro to avoid this message ??? or circumvent the message? -- thanks dr chuck |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy and paste and clipboard contents message
Try the DisplayAlerts Property. This can be used to turn off alerts during
execution. Be sure to set the property to true at the end of the Macro. "dr chuck" wrote in message ... I am copying and pasting data using a macro. After the data is successfully copied and pasted i get a message: Large amounts of data are on the clipboard do you want to be able to paste this data into a program later? yes no cancel. Can i just clear the clipboard in my macro to avoid this message ??? or circumvent the message? -- thanks dr chuck |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy and paste and clipboard contents message
Hello Dr Chuck, DisplayAlerts will automatically select the default button on the dialog. I have never had the dialog you describe be displayed so I don't which button is the default. You can try clearing your clipboard before the macro exits by using this line of code... Application.CutCopyMode = False Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=554812 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy and paste and clipboard contents message
Leith,
Thanks. The code is exactly what i was looking for. -- dr chuck "Leith Ross" wrote: Hello Dr Chuck, DisplayAlerts will automatically select the default button on the dialog. I have never had the dialog you describe be displayed so I don't which button is the default. You can try clearing your clipboard before the macro exits by using this line of code... Application.CutCopyMode = False Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=554812 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy/paste without using clipboard? | Excel Discussion (Misc queries) | |||
| clipboard copy & paste | Excel Discussion (Misc queries) | |||
| Copy outside Clipboard contents (html page) to a cell in Excel | Excel Programming | |||
| Copy outside Clipboard contents (html page) to a cell in Excel | Excel Programming | |||
| Paste contents of windows clipboard into a vba 2d array? | Excel Programming | |||
Hybrid Mode
