Hi Shyam, Thank you for your help. I used similar code to disable the copy/cut/ paste on the key combination and on the toolbar and right click. It works well. However, when one has the clipboard pane opened, one can still copy and paste using the command in the pane. When I used 2003, I can pretty much disable all the copy/cut/paste functionality. However, one can always open the 2003 file in Excel 2007, open the clipboard pane, copy or cut using the command on the ribbon, and paste the copied object by clicking on the object inside the pane. As it is not easy to modify the ribbon (through changing in XLM), I did not look into that option.
The easiest way to avoid user from copy the current content to other workbooks, if possible, is to empty the clipboard as it will ease all the possible ways (ex: insert the copy/paste command from toolbar option into the workbook) that people use the copy/paste functions. So again, we are back to our starting point - how to empty the clipboard programmatically. Kavita showed a method to do this, but it does not work as it cannot stop the copied object to appear on the clipboard. For AJ, this method applies the effect at the Excel "application level" and not on Excel "workbook level". How can we set it up so that the users will have this option setting on their end without asking them to do this on their own? Also, how can we stop them from turn the functionality back on? 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
