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 |
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 |
All times are GMT +1. The time now is 09:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com