ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Custom FaceID's for Custom Menus (https://www.excelbanter.com/excel-programming/354694-custom-faceids-custom-menus.html)

triaz[_4_]

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


Bob Phillips[_6_]

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.




triaz[_4_]

Custom FaceID's for Custom Menus
 
Thank you.



All times are GMT +1. The time now is 09:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com