Hi All, You can try the following code in vba to clear clipboard. Dim ClipBoard As DataObject Set ClipBoard = New DataObject ClipBoard.SetText "" ClipBoard.PutInClipboard
Regards Kavita --- On Thu, 4/3/10, Excel 009 <excelmodel...@gmail.com> wrote: From: Excel 009 <excelmodel...@gmail.com> Subject: $$Excel-Macros$$ How to clear clipboard effectively? To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com> Date: Thursday, 4 March, 2010, 10:46 PM Hi All, I am trying to disable copy/cut/paste functions on an Excel file. I implemented the following code: Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Application.CutCopyMode = False End Sub It works fine when clipboard pane is not opened/displayed. But when the clipboard pane is opened, the copied element appears in the clipboard and I can still paste it by clicking the element in the clipboard. Could anyone help? 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 The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ -- ---------------------------------------------------------------------------------- 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
