LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy/paste without using clipboard? Ming[_2_] Excel Discussion (Misc queries) 12 October 5th 09 02:42 PM
clipboard copy & paste SAGknot Excel Discussion (Misc queries) 1 June 12th 07 01:36 PM
Copy outside Clipboard contents (html page) to a cell in Excel sifar Excel Programming 9 September 12th 05 11:46 PM
Copy outside Clipboard contents (html page) to a cell in Excel sifar Excel Programming 2 September 3rd 05 03:40 AM
Paste contents of windows clipboard into a vba 2d array? Flystar[_16_] Excel Programming 1 May 29th 04 03:18 AM


All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"