Copying Custom Toolfaces

[Guest]

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

 

[Bob Phillips]

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)