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

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"pixiecat" wrote in message
...
I'm not finding PasteFace anywhere. I did a search for more information
and
came up with nothing, both in Help and in this forum. What I'm trying to
do
is copy the custom toolbar buttons I made for my custom macros in Excel
2003
to Excel 2007.

"Bob Flanagan" wrote:

It sounds like you are using Excel 2007. Copy and paste image are
available
via macros. To do a custom face, Copy the image into Excel. It can be
any
size. Then copy it and do a PasteFace to put the image on the button.

I suspect the reason the features disappeared is that it gave the users a
lot of freedom to customize Excel. And that resulted in support calls to
Microsoft, which in turn cost them money. No feature, no support calls,
more profit......

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel



"MSThinksItKnowsBetter"
wrote in message
...
In Excel 2003 I created numerous Macros for repeated functions that
aren't
available from MS. I then created (designed) my own Toolbar buttons to
easily
run these Macros. Why isn't that "Copy Image" "Paste Image" and "Edit
Image"
function still available for Modifying Toolbars?

Once again MS thinks it knows better!