Using .bmp or .ico for custom excel toolbar buttons

[Guest]

Hello...When you go to toolbars>customize and select the custom button (smiley face) is there a way to select an icon or bitmap image on your PC versus trying to draw that picture by coloring in all those squares?
For example I have some worksheets in excel that have my company's Logo and it would be nice to insert their Logo on the custom button versus trying to draw it up.
Thanks

He4Giv

 

[Don Guillett]

look here
http://tinyurl.com/ub9t

--
Don Guillett
SalesAid Software
(e-mail address removed)

Hello...When you go to toolbars>customize and select the custom button

(smiley face) is there a way to select an icon or bitmap image on your PC
versus trying to draw that picture by coloring in all those squares?

For example I have some worksheets in excel that have my company's Logo

and it would be nice to insert their Logo on the custom button versus trying
to draw it up.

 

[Bob Phillips]

Firstly, you need VBA.

Then, in essence, you need to have the icons as an image somewhere and load
the
shape. I do this by putting them 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)

Hello...When you go to toolbars>customize and select the custom button

(smiley face) is there a way to select an icon or bitmap image on your PC
versus trying to draw that picture by coloring in all those squares?

For example I have some worksheets in excel that have my company's Logo

and it would be nice to insert their Logo on the custom button versus trying
to draw it up.