Copying Custom Toolfaces
 

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

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