View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Copying Custom Toolfaces

Hi Eloy,

cbTable.Shapes(shapename).Copy*Picture
cbCtl.PasteFace

where cbTable is the codename of the sheet containing the picture, shapename
is the name of the shape, such as 'Picture 30', and cbCtl is an object
variable for the control being added.



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Eloy" wrote in message
...
Hi,

I have a routine in Excel 4 macro language that creates a toolbar with
custom faces. These toolfaces are little bitmaps that reside on my
spreadsheet and when I create the toolbar I copy and paste each on onto

it's
respective tool.

I am looking to convert this routine into VBA and I am having trouble
finding the command that allows me to paste my little bitmaps onto the

tools.

Can someone help me on this?

Thanks,
Eloy