Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Toolbar
I would like to create an Excel toolbar using vba but the faces on the buttons should need to be of an non standard face type. Is this possible to do in Excel? Or if not what tool/s should I use to do this Thanks in advanc Geof |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Toolbar
Geoff,
It is easy enough. Just copy the images into a hidden worksheet, give them meaningful names, and apply them 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) "Geoff" wrote in message ... I would like to create an Excel toolbar using vba but the faces on the buttons should need to be of an non standard face type. Is this possible to do in Excel? Or if not what tool/s should I use to do this? Thanks in advance Geoff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel toolbar like word toolbar, please | Excel Discussion (Misc queries) | |||
Form Toolbar verses Control Toolbar | Excel Discussion (Misc queries) | |||
Adjusting toolbar size, restore toolbar | Excel Discussion (Misc queries) | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming | |||
saving toolbar buttons on custom toolbar | Excel Programming |