Normally to clear the clipboard I use
However, this doesn’t work when I’ve copied a Shape in 2010. Anyone know how to clear the Clipboard of a copied Shape?Please Login or Register to view this content.
Normally to clear the clipboard I use
However, this doesn’t work when I’ve copied a Shape in 2010. Anyone know how to clear the Clipboard of a copied Shape?Please Login or Register to view this content.
Two ways:
Please Login or Register to view this content.
Thanks Kenneth – I appreciate the help. I got the first method to work perfectly. I’d like to understand the second one too. When I try that code I get a compile error “User-defined type not defined” on the line “Dim MyDataObj As New DataObject” of code. Any ideas?
Thanks again for the solution.
Thanks Shg - That fixed it. I would have never figured that one out. Is a list of those common References I should have turned on? Currently I have:
Visual Basic for Applications
Microsoft Excel 14.0 Object Library
OLE Automation
Microsoft Office 14.0 Object Library
Microsoft Forms 2.0 Object Library (Just added)
Also, I notice I can change the priority of an item up or down. Is there a preferred order to these items? Thanks for the assistance.
It is best to just add the object references as needed per VBAproject. Order does not matter. I normally comment that a reference is needed which is why I had a comment to Chip Pearson's web site that explains that and more.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks