View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kyoux Kyoux is offline
external usenet poster
 
Posts: 2
Default clear clipboard after Add-ins Toolbar creation

Hello,
I've an add-ins that creates a new toolbar each time a new
workbook has been opened. I put personalized pictures on
the buttons by copy-pasteface them from one worksheet. The
problem is that the clipboard keeps them so that when
opening a new book, if I want to paste something, it paste
the latest picture from the clipboard.
Set Icon = OEProject.Sheet1
Icon.Shapes("Picture 50").Copy
MyButton.PasteFace
I saw the function Clipboard.Clear on the Net
but "Clipboard" is unknown in my VBA, even in the
ObjectBrowser.
I really don't know how to fix this, could anyone help?