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 Custom FaceID's for Custom Menus

The emthod that I use is to create image files and paste that image into a
hidden worksheet. I rename the shape in that worksheet, and use code like
this when building a menu dynamically

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 Phillips

(remove nothere from email address if mailing direct)

"triaz" wrote in message
oups.com...
How do I go about creating custom FaceId's for my custom menus? I need
the faceid's to be distributable as the tool will be used by many
users.

Regards

T.