Excel Toolbar

G

Geoff

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
 
B

Bob Phillips

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 said:
I would like to create an Excel toolbar using vba but the faces on the
Click to expand...
buttons should need to be of an non standard face type.
 
Top