Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ryan ,
As I said, I do this by putting the pictures on a hidden sheet on the workbook that the commandbar is created from, with code somewhat like cbTable.Shapes(shapename).CopyPicture 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 ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "RJ Lohan" wrote in message ... Thanks, I'll give that a try. How do I reference the pictures from the worksheet? Cheers, Ryan Bob Phillips wrote: If you put the icons on a worksheet you can paste them from there, no need to ship separately from the add-in. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
globally adding a value across worksheets | Excel Discussion (Misc queries) | |||
Adding custom list and text boxes to the custom tool bar from Excel C API | Excel Discussion (Misc queries) | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming | |||
How can I get into VBA for a custom toolbar - Excel 97 | Excel Programming | |||
saving toolbar buttons on custom toolbar | Excel Programming |