Thank you, Kavita, for your help.  I placed the code in Private Sub
Workbook_SheetSelectionChange() and also run it under a sub, but still
cannot stop the copied object to appear on the clipboard or clear the
clipboard.

It seems like wheneve the clipboard pane is displayed, there is no way
to stop the objects from being "saved" in the pane.  Any new idea will
be appreciated?

Excel 009

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Reply via email to