View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Putting an image into the clipboard

Turn on the macro recorder while you do Insert=Picture in the menu to get
your picture on the worksheet. Then select the picture and do Edit=Copy.
That gets it on the clipboard. Now you can do customize, select the button
and do PasteFace. Turn off the macro recorder.

Just to add a little more detail.

--
Regards,
Tom Ogilvy

Bob Phillips wrote in message
...
Jonathan,

I load the pictures onto a hidden worksheet, and then just use the

PasteFace
method to get them by name. Far easier than all that you are going

through.

--

HTH

Bob Phillips

"Jonathan Crow" wrote in message
...
i am trying to create a custom icon for a custom control
button. I have gone through all of the knowledgebase
articles about how to do this and have copied the code
into my module but I always get to the part where it tell
me to put the image into the clipboard by using the
Clipboard.SetData command. Well, it never works, I have
tried:

Dim MyIcon as StdPicture
Set MyIcon = LoadPicture("C:\someiconfile")
Clipboard.SetData MyIcon

the LoadPicture seems to work but when I get to the
Clipboard line it tells me "Object Required". I have tried
all of the variations I can think of
Cliboard.SetData MyIcon, 2
MyIcon.PutInClipboard

Nothing seems to work. Any ideas?

From there I think it will be pretty easy to do a
PasteFace onto the control button.

thanks,
jonathan